How To Use Advanced Pivot Tables to Make Data Analysis Simpler Than Ever
Learn how to use the advanced pivot technique in Power Query to easily pivot messy data where you have text, dates, and currency values in various rows and you want to pivot these into their own separate columns. Using the advanced pivot technique in Power Query will help you analyze your data faster, save you time and no formulas needed! And as this is Power Query your pivot table is dynamic, just hit refresh and your query automatically updates!
You can download the practice example here: https://docs.google.com/spreadsheets/...
Timestamps:
00:00 Example 1
00:29 The Messy Data to Pivot
01:12 Add Index
01: 46 Add Conditional Column
2:14 Fill Down
02:34 Pivot the Data
03:55 Example 2
04:25 Columns to Fill Down
04:31 Pivot the Data
05:58 Advanced Editor Video
✅ Please see link to videos mentioned in this video:
🎦 Power Query Advanced Editor: • Getting Started with the Power Query Advan...
🎦 Power Query Custom Functions: • Power Query Custom Functions - Easily Crea...
🎦 Power Query VLOOKUP: • 5 Ways to Use Merge in Power Query & Make ...
🎦 Power Query Parameters: • Power Query Parameters - Dynamically Chang...
✅ 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
✅ For more Power Query videos please use the links below:
🎦 Power Query in Excel Beginners Tutorial: Combine Multiple Excel Sheets, Automate & Transform Data: • Excel's Power Query: The Ultimate Beginner...
🎦 Power Query Age Analysis - Create an Excel Age Analysis Report Using Power Query: • Power Query Age Analysis - Create an Excel...
🎦 Power Query Error Handling - How to Deal with Power Query Errors Part 1: • Power Query Error Handling - How to Deal w...
✅ Please also check out my Excel course on Udemy, please use this link:
📖 https://www.udemy.com/course/excel-fo...