How to Merge Excel Files with Different Headers in Power Query

Microsoft Excel

Consolidating data from multiple Excel files requires you to have identical table headers otherwise you can run into the missing data problem. With this Power Query Advanced tutorial you learn how to handle a complex situation where you need to combine data from multiple Excel files but it’s not easy to match the columns.

Credit Leila Gharani