Tag Archives: Table.Combine

Combine different ranges of data across worksheets in #Excel using Power Query

Posted on March 20, 2021 by MF

In the previous blogpost, I showed you how to use INDIRECT to prepare a summary table based on values from different ranges across worksheets. In this post, I am going to show you how to do that with Power Query. … Continue reading →

Rate this:

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

Transform and Combine all worksheets in an #Excel workbook with #PowerQuery

Posted on April 19, 2020 by MF

Power Query is magically powerful, yet it is not well known to majority of Excel users.  I think most Excel users are not even aware of its existence…  So, let’s talk about how Power Query could solve a real-life problem … Continue reading →

Rate this:

Posted in Power Query | Tagged , , | 2 Comments