Combine Multiple Excel Files with Inconsistent Column Headers the Right Way!

Easily combine multiple Excel files with inconsistent column headers in just four steps. And when new data is added you just need to hit refresh and your data is updated automatically even if your new data has completely different column names to your original data!

✅ Please see links to videos mentioned in this video:

✅ Please see links to 'The Query Editor' newsletter articles mentioned in this video:

✅ If you would like to connect on LinkedIn:

✅ If you would like to support the channel by buying me a coffee, (it's really quick and easy), please use this link:

✅ For more videos please subscribe:

[AnilKumar-vioe]

Missed you so much, thanks for bringing much needed content....

[pascaljoly]

thanks for the video. i have had this issue recently where i receive a lot of similar files but some of them changed the name of a column so the query wouldn't work. but since there are only 5 columns i did the following instead, which was very quick; in the sample file, i deleted the promote headers step, so they became the first row, which i deleted and then typed in manually the new column names. which means it doesn't matter if they send me the files with any different column names as they'll be ignored. i have downloaded your video though as i think it's interesting; i don't think i'd have been able to do it like you or i might have tried something else using the tablecolumnnames function. i might try. thanks again

[Angel-krcw]

Your Videos are so helpful …. Thank you very much

[martinmoko]

i have a problem to combine multiple sheet that have different header to make one table report ? may i direct email file to you? or maybe any tutorial ? kindly help, thank you

[cheikhhakim]

thank you Miss clearly explained as usual

[ronniebornman]

Thank you this was so clearly explained. Very useful!!

[mohammedelsakally]

Thank you for your valuable video as usual, i suggest to prepare a video combing some of your videos starting from dynamic path then combine data from different files with Inconsistent headers without using PQ function and avoid redecousily slow loading when dealing with a big data conatining a millions of rows.

[mcwahaab]

Thanks, as always. A quick question. Instead of combining 3 files in the current case, what happens if the files are 20 or even 30 and we also want to transform some of the column headers but there are others to be removed. Any more advanced approach to handle such complex issue?

[mcwahaab]

Thanks, as always. A quick question. Instead of combining 3 files in the current case, what happens if the files are 20 or even 30 and we also want to transform some of the column headers and not all. So there are some column headers to be removed. Any more advanced approach to handle such complex issue?. Plz advise

[pittwood]

Wow! Great video! 💪
Do yout think, is there any solution for union in PQ .xlsx files with difrerend numbers of columns and order?
Ex. file 1 has col. A, B, C.
File 2 has col. B, C, D.
FIle 3 has col. A, B, C, D.
File 4 has col. A, C, B.
In the end i want to get ALL files from folder in 1 table with col. A, B, C, D (all colums).
Is it possible?

[RogerStocker]

I indeed was wait for new content from you. Sorry I just saw another Video with similar topic. Watch how Chandeep is solving it.