Pivoting Daily Data

[AndrewB]

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

[AndrewB]

Thank you both!

[ribisht17]

@AndrewB 

@mahoneypat  is right!

Since you are new I am sharing this video https://www.youtube.com/watch?v=W6UeZCte9YM

Thanks,

Ritesh

[mahoneypat · Accepted solution]

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