Tag Archives: Combine Workbook

Combine files of (slightly) different layouts in a folder with Power Query in #Excel

Posted on January 24, 2021 by MF

Part 2 – What if we have inconsistent table structures across files? Note: this is a long post. 😉 This is the continuation of previous post. Suggest you read that post first if you are new to Power Query. Moreover … Continue reading →

Rate this:

Posted in Power Query | Tagged , | Leave a comment

Combine files in a folder with Power Query in #Excel

Posted on January 17, 2021 by MF

Note: This is a long post… 😉 Part 1 – What Power Query does for us in the process? If you know about Power Query, you should know that combining files in a folder is a powerful yet simple task … Continue reading →

Rate this:

Posted in Power Query | Tagged | Leave a comment

Combine all visible worksheets from multiple #Excel files in a folder

Posted on August 11, 2020 by MF

It is a common task for us to combine all worksheets in a workbook. It could be a time consuming task without Power Query. With Power Query, it’s piece of cake. 😁 Wait? What about if you want to combine … Continue reading →

Rate this:

Posted in Power Query | Tagged , , , | Leave a comment