Combine Files with Different Headers in Excel Power Query!

Learn how to combine files with different headers in Excel Power Query. This tutorial will show you how to merge data even when the headers don't match perfectly. Master this skill and streamline your data processing!
Combining data from various Excel files can be challenging if their table headers don't match, potentially leading to missing data issues. In this advanced Power Query tutorial, you'll discover strategies for navigating such complexities when merging data from multiple Excel files with differing column header names.

[@alexrosen8762]

Great solution 👌

[@mikezhang8861]

Genius

[@91lovemusic]

Hi. Let say in column got “member” and “non member”register.
How to count how many people is “member” and how many people “non member”?

[@ExcelWithAnser]

I think you should be able to solve that with a formula, rather than Power Query. Say you have the Status in Column A (Member or Non-Member). You can simply do =countif(A:A, "Member") to see how many Members you have, and =countif(A:A, "Non-Member") to see how many non-members you have.

[@DaeViZ0n3]

This just ignores the headers, it does not merge them in case they are also in a different order

[@ExcelWithAnser]

Thanks for your comment!

[@samuelakinjise2860]

Please I have excel more 50 sheet in Excel some has the same headings some don't. How do I merge the headings that have the same and put the one that has diff in the s AME sheet