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...