Forum

Notifications
Clear all

Columns to rows

3 Posts
2 Users
0 Reactions
96 Views
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Hi Team,

I tried to load my pay allocation template to power query and tried to achieve expected result by doing unpivot. However I did not quiet get the result I required. Please let me know how can I transform those columns to stacking rows while fixing some columns.

Or please refer me to the course guide to repeat to get the idea.

I have attached my working and expected result.

Many thanks and Regards,

Aye

 
Posted : 09/05/2019 9:10 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Aye,

It's in the Unpivot lesson. See file attached.

Mynda

 
Posted : 10/05/2019 7:00 am
(@ayemu7)
Posts: 197
Reputable Member
Topic starter
 

Thank you so much, Mynda.

This is so great. It will save so much time for me.

Regards,

Aye

 
Posted : 10/05/2019 7:19 pm
Share: