Combine Files With Inconsistent Columns In Power Query

Learn how to combine files in a folder when the data in the files has inconsistent column headings and table names. 👇

Check out my full courses and ebooks here

DOWNLOAD the example workbook here

SUBSCRIBE & get my 3 FREE eBooks

CONNECT with me on social

Thanks for all your support!

[HowToExcelBlog]

Check out my full courses and ebooks here

[JoshuaBerkheimer]

Had to combine almost 3000 .csv files with varying headers. I only cared about a few of the common headers in each file and helped me get what I needed - thank you!

[franciskinsler]

What an amazing solution. Works like a dream and has solved my problem. As you add additional files, will need to ensure that the filter is amended to include the table from the new file each time.

[faezesafari]

Wow!! This was a life saver. Thank you!!!

[SMH]

Thanks so much. I was searching for how to combine files with unmatched headers and sat through a few videos before I found yours. what a life saver.

[mandyliu]

Amazing, I searched everywhere to get a solution on fixing this. None of it works or not to this issue at all, until I saw this video and it solved my problem. Thank you so much. However, what I don't understand is each of the workbook are exactly the same in structure, however Power query still throws error, unless I do this way. weird.

[brunomason]

Your getting a super like for this. Even though its a old video.

[danielshepherd]

Unbelievably good video. This is what the internet was invented for.

[tomasalberio]

I love you, thanks for you help. I needed this for Power BI and couldn't find solutions :)

[EnkhturDamdinjav]

Hi, thanks. Question: At the end, we have our data in two different columns... Can you teach us how to fix them inside query editor?

[garethhill]

Thanks, that was really useful and easy to follow.

[EdoardoCasella]

Boom! Thanks Buddy, just solved hours of work

[jserr]

excellent video, was having problems now its fixed!

[noridale]

Thank you for this video. This is very helpful

[screaminbrod]

this is awesome. I gotta ask, is this possible when files are in sharepoint or using the Sharepoint.Contents syntax?

[jasonjackson]

Nice trick. I would merge the data columns as a final step before loading to a table.

[qcasares]

This got me out of a huge bind - THANKS!!!

[ayandapeter]

Impressive Sir, I like the approach, I'm subscribing for sure

[imranali-iywk]

I have a folder containing 19 Excel worksheets with each worksheet containing 16 sheets inside it. While the name of the excel files are different, the name of individual sheets inside them is same i.e. they start from "Sheet 1" and go till "Sheet 16". What I have to do is append each sheet at the end of the next one and continue the same to get a new excel file containing only one sheet. (In other words, sheet 1 from file two (say, B) will be appended at the end of sheet 1 from file one (say, A) and sheet 1 from file three (say, C) will be appended at the end of the above two files containing sheet 1 from files A and B, respectively and so on untill every file is added).

[Metzanine]

@howtoexcel From your final output, how would you get the A and B column data to line up into a single column?