Combine Data from Multiple Excel Files with Inconsistent Column Names

Check out our newly launched M Language course ↗️ - https://goodly.co.in/learn-m-powerquery/ In this video, we will learn how we can combine data from multiple excel files which contain different column names. We will also learn how to create a mapping table & plug that as the rename the inconsistent column names! ===== ONLINE COURSES ===== ✔️ 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/combine-data-from-multiple-excel-files-with-inconsistent-column-names-in-power-query/ ===== CONTACT 🌐 ===== Twitter - https://twitter.com/chandeep2786 LinkedIn - https://www.linkedin.com/in/chandeepchhabra/ Email - [email protected] ===== CHAPTERS ===== 0:00 Intro 0:20 Explanation of the Problem & Data 1:27 Understanding the Logic 3:55 Getting all the Column Names 8:01 Creating the Mapping Table in Excel 9:28 Combining the Data & plugging in the Mapped Table 15:47 Testing the Query 17:41 My Courses ===== 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! - - - - - Music By: "After The Fall" Track Name: "Tears Of Gaia" Published by: Chill Out Records - Source: https://goo.gl/fh3rEJ​ Official After The Fall YouTube Channel Below https://www.youtube.com/channel/UCGQE...​ License: Creative Commons Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) Full license here: https://creativecommons.org/licenses