Advanced Power Query - Unpivot Columns with Multiple Headers

Ever struggled with transforming reports that had columns with multiple headers? The struggle was real! I will show you a clever technique that elegantly transforms data with multiple headers (there can be more than just two as in our example) into nice tabular data.

You will find useful these advanced Power Query methods in other scenarios also, so it is worth learning them. The identical method can be applied in Power BI.

#PowerBI #powerquery #dataanalytics

[tmack]

This is exactly the solution I was looking for. I've liked and subscribed, looking forward to learning more from your valuable video tutorials.

[syedaneesdurez]

Explained in very simple way. Thank You

[balaedge]

Awesome!!
I was breaking my head to do this so far..

[WaqasGulll]

Thank you so much. So nice of you, i was looking for that from so long, i have monthly data quantity and value 2 columns down to every month and i am needing it to columns to make a dashboard but i was unable due to horizontal data

[bharathau]

Thank you, I was looking for his. It is so helpful.

[rajeevgosavi]

Great Technique Sir, Kindly share practice file used in here to follow along. Thanks Again.

[oyetundebello]

What I don't really understand is why you would want to do this
The data is well summarised in the cross tabulation already

[sureshnetala]

please provide sample file for practice