Advanced Unpivot in Power Query - Transpose Multiple Columns & Multiple Headers Without Any Formulas

Learn how to use advanced unpivot in Power Query when you have data with multiple columns and multiple headers and you want to transpose these columns to rows, so you want to unpivot this data before it was pivoted so that you can perform further data analysis. In example one learn how to use unpivot when you have multiple headers and in example 2 learn how to use advanced unpivot when you have multiple headers and multiple columns to transpose. Every step is really important to progress to the next step but if you prefer to skip ahead please use the timestamps below.

Timestamps:
00:00 The End Result
00:37 Example 1 - The Source Data to Unpivot
01:19 How to Unpivot or Transpose Multiple Columns in Power Query
02:19 Example 2 - The Source Data to Unpivot
02:46 How to Unpivot or Transpose Multiple Columns & Multiple Headers in Power Query

✅ Please see link to videos mentioned in this video:

✅ If you would like to connect on LinkedIn:

✅ If you would like to buy me a coffee, so I can get my caffeine in to keep creating as many videos as possible for you :). It's really quick and easy, please use this link:

✅ For more videos please subscribe:

✅ Please also check out my Excel course on Udemy, please use this link:

[emmdee]

Super. I had a very strong need to be able to do this and you solved it. A fellow South African I believe😁

[wayneedmondson]

Great unpivot examples! Thanks for demonstrating. Thumbs up!!

[ildikojanosi]

Thanks a lot, this is exactly what I was looking for!

[syedaneesdurez]

Thank you for explaining in very simple steps

[felixn]

Excellent video. In addition, the excel file to do the exercises is simply great.
Congratulations

[yhharishadyar]

Very good information, but music is ruined