Advanced Power Query - Unpivot Columns with Multiple Headers
Рет қаралды 10,087
Жыл бұрын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 3 ай бұрын
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 3 ай бұрын
Awesome, thank you!
@Data.Analytics.Central 3 ай бұрын
Glad to be of help!
@rajeevgosavi4514 14 күн бұрын
Great Technique Sir, Kindly share practice file used in here to follow along. Thanks Again.
@syedaneesdurez7197 Жыл бұрын
Explained in very simple way. Thank You
@Data.Analytics.Central Жыл бұрын
Thanks for the feedback, Syed!
@bharathau8085 3 ай бұрын
Thank you, I was looking for his. It is so helpful.
@Data.Analytics.Central 3 ай бұрын
Glad it was helpful!
@balaedge 10 ай бұрын
Awesome!! I was breaking my head to do this so far..
@Data.Analytics.Central 10 ай бұрын
Thank you for the feedback! 👊
@PattareponS Жыл бұрын
thank you ❤
@Data.Analytics.Central Жыл бұрын
You’re welcome! 👍
@WaqasGulll 9 ай бұрын
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 9 ай бұрын
Thank you Waqas for the feedback. I am glad it helped you! 👊
@davidnavas9065 4 ай бұрын
Thank You 😁
@Data.Analytics.Central 4 ай бұрын
I am glad that you have found it useful!🤝
@sureshnetala1032 4 ай бұрын
please provide sample file for practice
@SaurabhSharma-ry8iz Жыл бұрын
Informative video sir
@Data.Analytics.Central Жыл бұрын
Hi Saurabh, I am glad that you found it useful!
Leila Gharani
Рет қаралды 375 М.
Efficiency 365 by Dr Nitin
Рет қаралды 3,6 М.
Excel Off The Grid
Рет қаралды 7 М.
Miss Microsoft
Рет қаралды 6 М.
MaviGadget
Рет қаралды 11 МЛН
Typecase
Рет қаралды 1,2 МЛН
i-shoppers обзоры
Рет қаралды 885 М.
lev89k
Рет қаралды 1,6 МЛН