Check out our newly launched M Language course ↗️ - In this video, I discuss five advanced data cleanup examples in Power Query that cannot be solved using the user interface alone. These examples include the double headers problem, working with pivoted data, combining data from multiple Excel files, and solving custom delimiter problems. #PowerQuery #MLanguage #Excel Data Cleaning Case Studies - Promote Double Headers in Power Query | Solution - Unpivot Cross Tabulated Data with Multiple Headers and Columns - Combine Data from Multiple Excel Files with Inconsistent Column Names - Advanced Power Query Case Study 🔴 (with downloadable files) - Solving Tricky Data Cleaning Problems using M in Power Query - ===== ONLINE COURSES ===== ✔️ M Language course ✔️ Mastering DAX in Power BI - ✔️ Power Query Course- ✔️ Master Excel Step by Step- ✔️ Business Intelligence Dashboards- ===== LINKS 🔗 ===== Blog 📰 - Corporate Training 👨‍🏫 - Need my help on a Project 💻- ===== CONTACT 🌐 ===== Twitter - LinkedIn - Email - @ ===== WHO AM I? ===== A lot of people think that my name is Goodly, it's NOT ;) My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI. Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!