Forum Discussion
Solved
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 ...
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
Thank you both!