Forum Discussion
Pivoting Daily Data
Hi all,
This seems like it should be fairly basic but I am just starting out with Power Query. I'm attempting to transform my data from top format into bottom format. Could anybody please advise best way to do this?
Regards,
Andrew
In the query editor, select your first column, then right click and choose Unpivot Other Columns. This will create your desired format with "Attribute" and "Value" columns you can rename (or update the names in the unpivot step).
Pat
3 Replies
In the query editor, select your first column, then right click and choose Unpivot Other Columns. This will create your desired format with "Attribute" and "Value" columns you can rename (or update the names in the unpivot step).
Pat
mahoneypat is right!
Since you are new I am sharing this video https://www.youtube.com/watch?v=W6UeZCte9YM
Thanks,
Ritesh
Thank you both!
