Forum Discussion
Solved
Table transformation
I need help with transforming a table that looks like this: Location Threshold Loc1 High Loc2 Low Loc3 Medium Loc4 Low Loc5 Medium Loc6 High Loc7 Medium Loc8 L...
rswami_4 Just use pivot table option under Transform tab via query editor. Choose values column as Location and under Advanced option 'Don't Aggregrate'.
rswami_4 Just use pivot table option under Transform tab via query editor. Choose values column as Location and under Advanced option 'Don't Aggregrate'.