Combine Data from Multiple Excel Files with Inconsistent Column Names in Power Query

Posted on November 15, 2022November 16, 2022 by Chandeep -

In this blog, 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!

Combine Data from Multiple Excel Files with Inconsistent Column Names in Power Query

Topics that I write about...

Chandeep

Welcome to Goodly! My name is Chandeep. On this blog I actively share my learning on practical use of Excel and Power BI. There is a ton of stuff that I have written in the last few years. I am sure you'll like browsing around. Please drop me a comment, in case you are interested in my training / consulting services. Thanks for being around Chandeep

Uncategorized

Combine Data from Multiple Excel Files with Inconsistent Column Names in Power Query