Forum Discussion
Can anyone help me in combining two columns data into one column and one column data into one row?
Hi All,
I have a raw data and I need to combine two columns (Status Mapper and Ultimate Group Mapper) into one column and one column data (Value Mapper) into one row , as shown in New Table. Can anyone please suggest how to do this.
| Raw Data | |||
| Status Mapper | Ultimate Group Mapper | Value Mapper | Item Counter |
| PL | DW | +$250m | 1 |
| PL | DW | +$250m | 1 |
| PL | SPG | +$30m | 1 |
| PL | DW | +$10m | 1 |
| TD | DW | Missing numeric value | 1 |
| PL | SPG | +$30m | 1 |
| PL | SPG | +$250m | 1 |
| TD | DW | -$10m | 1 |
| #N/A | #N/A | +$250m | 1 |
| New Table | |||||
| -$10m | +$10m | +$30m | +$250m | Missing numeric value | |
| PL | 1 | 2 | 3 | ||
| TD | 1 | 1 | |||
| DW | 1 | 1 | 2 | 1 | |
| SPG | 2 | 1 |
- I would suggest using a Matrix visual and keeping the raw data as is.
In Matrix visual:
Item Counter in Values (as SUM)
Value Mapper in Columns
Status in Rows
2 Replies
- AllisonKennedy
Community Champion
I would suggest using a Matrix visual and keeping the raw data as is.
In Matrix visual:
Item Counter in Values (as SUM)
Value Mapper in Columns
Status in Rows