Tag Archives: Combine Worksheet

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