Table transformation

[rswami_4]

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

[ankitpatira · Accepted solution]

@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'.