Combine data from multiple worksheets into a single worksheet

Combine data from multiple worksheets into a single worksheet

1 July 2018

This tutorial shows you the exact steps required to combine multiple sheets into one single table using Power Query.

When using Power Query to combine data from all the Tables in a workbook, you will likely face an issue where Excel double counts your data. The tutorial also shows you how to avoid this issue.

A sample workbook is available to download, so you can follow each of the steps yourself.