rswami_4Helper I10 years agoSolvedTable transformation I am looking for help to transpose/transform a table so that I could create a useful waterfall chart out of the output. For example: The source table looks like this: Wave Cat1 Cat2 Cat3 ...Show MoreVvelarde to rswami_410 years agoHi rswami_4 You can also do it by this way: Go to Edit Query Step 1: Select your columns Cat 1 to Cat 4Step 2:Go to Unpivot ColumnsStep 3: Step 3: Ready
Vvelarde to rswami_410 years agoHi rswami_4 You can also do it by this way: Go to Edit Query Step 1: Select your columns Cat 1 to Cat 4Step 2:Go to Unpivot ColumnsStep 3: Step 3: Ready
Vvelarde to rswami_410 years agoHi rswami_4 You can also do it by this way: Go to Edit Query Step 1: Select your columns Cat 1 to Cat 4Step 2:Go to Unpivot ColumnsStep 3: Step 3: Ready
VvelardeCommunity Champion10 years agoHi rswami_4 You can also do it by this way: Go to Edit Query Step 1: Select your columns Cat 1 to Cat 4Step 2:Go to Unpivot ColumnsStep 3: Step 3: Ready
rswami_4Helper I to Vvelarde10 years agoVictor, Thanks a lot. This exactly what I was looking for. Swami
Related contentTable TransformationTable TransformationTable TransformationTransform columns / typeTable Transformation
