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

[@777tmack]

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

[@Data.Analytics.Central]

Awesome, thank you!

[@Data.Analytics.Central]

Glad to be of help!

[@syedaneesdurez7197]

Explained in very simple way. Thank You

[@Data.Analytics.Central]

Thanks for the feedback, Syed!

[@rajeevgosavi4514]

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

[@balaedge]

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

[@Data.Analytics.Central]

Thank you for the feedback! 👊

[@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

[@Data.Analytics.Central]

Thank you Waqas for the feedback. I am glad it helped you! 👊

[@bharathau8085]

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

[@Data.Analytics.Central]

Glad it was helpful!

[@SaurabhSharma-ry8iz]

Informative video sir

[@Data.Analytics.Central]

Hi Saurabh, I am glad that you found it useful!

[@davidnavas9065]

Thank You 😁

[@Data.Analytics.Central]

I am glad that you have found it useful!🤝

[@PattareponS]

thank you ❤

[@Data.Analytics.Central]

You’re welcome! 👍

[@sureshnetala1032]

please provide sample file for practice