Combine, Consolidate or Append Multiple Tables from any source with Power Query for Excel

[@ivanrybalchenko7225]

Thank you! Excellent solution!

[@ryanwade865]

Great video Miguel! I was familiar with the "Excel.Workbook" function but not the "List.Combine" or "Table.Combine" functions. I like your use of combining multiple lists of tables using the "list of list" pattern. PowerQuery is powerful through the interfaces and even more powerful when you start modifying it using custom M code. I look forward to your book and I look forward to the possibility of taking your course in the future.

[@michaeljones2843]

This is an awesome example that I will be using daily Thank you!

[@BillSzysz1]

Thanks Miguel for sharing :-) Yes, absolutely agree... this is the most optimal way to combine many Tables from different sources. But one condition... you haven't any other worksheets with data in workbooks. Otherwise we have to check the headers of the tables and choose only the correct tables ( M code of course). Regards :-)

[@ThePowerUser]

Bill Szysz ! don't get too much ahead. That's part of the workshop that I'm doing with Ken :) - how to check those and make everything still run fast.

[@chelebarry]

Good video, it was a clear explanation.

[@chandru29v]

Miguel - thank you for sharing. What is the best way to combine multiple Excel files stored in a SharePoint "with format"? I am able to combine the files just fine using PQ but the format is lost.

[@ThePowerUser]

+Chandrashekar Venkatesan SharePoint.Contentst("SharePointSiteURL") is the function that you're looking for in order to get the files from SharePoint, but what exactly do you mean by format?

[@darrenvinales419]

Thank you very much!

[@vaal6990]

Share the data excel could be really nice from you! Nice video i follow your channel .Greetings from Costa Rica

[@ThePowerUser]

Hola! Lamentablemente no pude encontrar los archivos, pero este artículo te puede servir: www.poweredsolutions.co/es/2019/04/30/combinar-o-anexar-datos-patron-para-combinacion-optima/