How to Combine Tables Dynamically in Excel

Combine multiple worksheets, tables, or sets of data in Excel dynamically using Power Query so that any updates to the original data will appear in the consolidated data set.

This method, using Power Query, is very easy to use, and works in older versions of Excel as well as newer versions of Excel.

Steps

1. Select any cell in the first table.
2. Go to Data → Get & Transform Data → From Table/Range.
3. Power Query opens – rename it (e.g., Table1) and click Close & Load To... → Only Create Connection.
4. Repeat steps 1–3 for the second table (e.g., Table2).
5. Go to Data → Get Data → Combine Queries → Append.
6. Choose Two tables → select both Table1 and Table2.
7. Click OK → result is a stacked table with rows from both tables.

Download the File

Click the link below here or to the right of this tutorial to download the file - it's free!