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