Power Query: Merge and Append

How to use Power Query to merge and append Excel files and tables

[achong]

Thank you!! Your tip at 7:35 is the most important when merging. That is what helped me after hours of trying to figure out how to do this!

[nazarkamal]

This is what I expected basic of pq to understand ❤❤❤ thanks

[wildecorrea]

Congratulations on your effort to share your knowlegdes with us! Hi from Brazil!

[patriciailin]

Best video so far on this. Solved my problem. Thank you!!

[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).

[arturgarncarz]

That what i was looking for. Thanks for your vid! Regards from Poland :)
P.S. Next time try maybe to zoom out your vid so we can see everything you do.

[gr_excel]

great video, it's helping me... how do you add more queries to an existing append? Every time i try to do so, it creates a new append

[wadebrewer]

Im struggling to deal with error handling when appending tables. My queries are pulling late orders from a data bank in a separate workbook. When there are no late orders under one process....it tries to append an empty table....freaks out and crashes the workbook.

[Orholam]

if you didn't have the date in there, how would you know which query it came from....is there a way to add an indicator column to tell you which sheet each data point came from?

[riyazhashmi]

How to removed duplicate in merged the data?

[canefan]

What if you would’ve merged February deposits with March loans?

Would it just have blanks under loan column for February deposit rows? And blanks in the deposit column in March Loan rows?

[wayneseymour]

Why is excel power query adding a unwanted column to the appended table when I refresh the data ?

[Sabuz]

What is the difference between append vs merge ?

[sonupatel-rcms]

Can we just append all three files into sheet 1 without creating new sheets 1, 2, 3, append ?

[wayneseymour]

Why is excel power query adding a unwanted column to the appended table when I refresh the data ?