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 | Low |
| Loc9 | Low |
| Loc10 | Low |
to a table that looks like this:
| High | Medium | Low |
| Loc1 | Loc3 | Loc2 |
| Loc6 | Loc5 | Loc4 |
| Loc7 | Loc8 | |
| Loc9 | ||
| Loc10 |
I am wondering if this is possible in Query editor.
Thanks,
Swami
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'.
1 Reply
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'.