Hi all
I've been given a lot of data in a format like I've created in this exampleexample.png
I'm trying to unpivot the data with power query, so I can get the data in a standard table format, and create pivot reports from it.
I'm struggling with how to do this with multiple rows of headings. I've tried Merging and transforming and splitting - however I just can't get my head around how to do this!
Would really appreciate some help!
Thanks Anna
Bookmarks