8 Powerful Power Query Transformations You Must Know
If you have inconsistent or messy data watch this video to learn how to clean and structure your data by using these 8 powerful Power Query Transformations.
You can download the practice examples here: https://docs.google.com/spreadsheets/...
00:00 Data is Messy
00:20 Split Text into Their Own Rows
03:51 Fix Inconsistent Data E.g. 1
08:36 Report with Fixed Layout E.g. 1
09:51 Report with Fixed Layout E.g. 2
10:53 Report with Fixed Layout E.g. 3
12:02 Report with Fixed Layout E.g. 4
13:04 Change Columns to Rows of Data
14:24 Fix Inconsistent Data E.g. 2
✅ Please see link to videos mentioned in this video:
🎦 Power Query Error Handling - How to Deal with Power Query Errors Part 1: • Power Query Error Handling - How to Deal w...
🎦 Power Query VLOOKUP - How to Perform VLOOKUP in Power Query in Excel using Merge Tables: • 5 Ways to Use Merge in Power Query & Make ...
🎦 Advanced Unpivot in Power Query - Transpose Multiple Columns & Multiple Headers Without Any Formulas: • Advanced Unpivot in Power Query - Transpos...
✅ 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...