How to combine multiple Power Query tables/tabs together?

[ubergreen]

I can't seem to find the answer to this question, but it may be because I am not wording it correctly or using the correct terms to figure out the solution to my issue.

I have multiple excel folders that I want to be able to transform in Power Query into a single worksheet. Each excel folder has its own unique format, so I can't simply combine all of the folders together. Essentially, from each folder, I want to extract one or two columns of data and then add them into a single worksheet.

 

[Matt Allington]

What is an Excel folder?

 

[ubergreen]

What is an Excel folder?

I guess what I meant to say was the data source folder for where the power query files gets the data from?

 

[Matt Allington]

OK. You will need to do a Get Data\From File\From Folder and then do a file combine for each of the folders independently. In each of these transformations, you will need to end up with the same table layout (ie the same column names). Then you can append them all together.
This may help you Understanding Power Query Combine