Pivot and Unpivoting columns in table

[Anonymous]

Hi Team,

I have table in Tranform data : 

Id	Attribute	Value
11	Premium	600
11	Percentage	9%
11	Tax	55.8

and I wanted to show it like :

Id	Premuim	Percentage	Tax
11	600	9%	55.8

Could you please let me know on which column should i use Pivot/unpivot so that i will get correct result ?

Thanks,

Shubham

[Anonymous]

You can also select transpose under transform in query editor. 

[JIGAR · Accepted solution]

@Anonymous 

Select the Attribute column and do a Pivot on it. See the screenshot below to see what you have to set in Values column and aggregate function

This is how the result will look like.

Thanks