Power Query - Transpose

[Anonymous]

Dear all,

Hi! I started to use Power BI for the last two months. When I try to transpose a certain column I got an issue. It would be very helpful if you could help me to fix the issue.

So my question is...

How to transpose the table format in Sheet 2 to look like Sheet 1 in the power query editor

I have attached the file link for your reference.

https://entuedu-my.sharepoint.com/:x:/g/personal/srinivas010_e_ntu_edu_sg/ERlA7y8yJ8dLuJ_D_nxDTkgBfI...

Thanks

[Mariusz · Accepted solution]

Hi @Anonymous 

1. Select all month year columns, and press Unpivot in Transform Ribon.

2. Next, select Column TRADE and Values and press on  Pivot Columns.

Hope this helps.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.