Smart Way to Combine CSVs with Inconsistent Headers in Power Query

📘 My book teaches you how to break down real Power Query problems—step by step. Get your copy here → https://goodly.co.in/power-query-book/ Have you ever tried to combine multiple CSV files in Power Query... …but the headers don’t match across the files? In this video, I’ll walk you through how to combine multiple CSVs with inconsistent headers — where the column order is the same, but the column names are different. We’ll start by exploring what Power Query does using the UI, and then move on to writing a dynamic M code solution that works across all your files — even when new columns are added. You'll learn how to: ✔ Read CSVs using the CSV.Document function ✔ Rename inconsistent headers dynamically ✔ Use List.Zip to pair original and new column names ✔ Safely expand and combine all tables — even if some have extra columns If you regularly combine files from a folder or deal with messy, inconsistent headers, this technique will save you hours. ===== ONLINE COURSES ===== ✔️ Master 'M' in Power Query - https://goodly.co.in/learn-m-powerquery/ ✔️ Mastering DAX in Power BI - https://goodly.co.in/learn-dax-powerbi/ ✔️ Power Query Course- https://goodly.co.in/learn-power-query/ ✔️ Master Excel Step-by-Step- https://goodly.co.in/learn-excel/ ✔️ Business Intelligence Dashboards- https://goodly.co.in/learn-excel-dashboards/ ===== LINKS 🔗 ===== Blog 📰 - https://www.goodly.co.in/blog/ Corporate Training 👨‍🏫 - https://www.goodly.co.in/training/ Need my help on a Project 💻- https://www.goodly.co.in/consulting/ Download File ⬇️ - https://goodly.co.in/how-to-merge-multiple-csv-files-into-one-with-different-headers/ ===== CONTACT 🌐 ===== Twitter - https://twitter.com/chandeep2786 LinkedIn - https://www.linkedin.com/in/chandeepchhabra/ Email - [email protected] Download File ⬇️ - https://goodly.co.in/how-to-merge-multiple-csv-files-into-one-with-different-headers ===== 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'll find a ton of interesting videos that I have created :) Cheers!