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.
You can download the practice example here: https://docs.google.com/spreadsheets/...
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:
🎦 Learn Power Query in Excel for Beginners: • Excel's Power Query: The Ultimate Beginner...
🎦Power Query Error Handling - How to Deal with Power Query Errors Part 1: • Power Query Error Handling - How to Deal w...
🎦 Advanced Pivot Table Techniques - Use Power Query to Easily Pivot Text & Other Messy Data: • How To Use Advanced Pivot Tables to Make D...
🎦 Power Query Age Analysis - Create an Excel Age Analysis Report Using Power Query: • Power Query Age Analysis - Create an Excel...
✅ If you would like to connect on LinkedIn:
🤝 www.linkedin.com/in/missmicrosoft
✅ 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:
☕https://www.buymeacoffee.com/missmicr...
✅ For more videos please subscribe:
🔔 / @missmicrosoft
✅ Please also check out my Excel course on Udemy, please use this link:
📖 https://www.udemy.com/course/excel-fo...