Is the below transformation possible in PowerBI (Transform Data - Power Query editor)

[Anonymous]

Hello everyone,

Is the below transformation possbile in Power Query Editor? I tried unpivot columns but couldn't get the desired solution or I might have wrongly applied.

Input:

Output:

Thanks,

Karthik

[samdthompson · Accepted solution]

this is definitely doable in power query. 

select the categoy column and pivot over amount as values:

[Anonymous]

Thank you so much I tried multiple times "unpivot colums" and never noticed there was a option for "pivot columns". You saved lot of unnecessary steps and tables.

[samdthompson]

ha. i loose it all the time too. theres something about the positioning of it that i can never see.