Combine Two Excel Tables Automatically with Power Query
Question details
Combine two expense tables from separate Excel workbooks into one refreshable table.

- Product
- Microsoft Excel Power Query
- Device & OS
- not provided
- Scenario
- Project A Expenses and Project B Expenses have matching headers and need to feed a combined Total Expenses table.
- Observed behavior
- The combined table should include new rows from both source tables when the query is refreshed.
Make sure each source range is formatted as an Excel table and that the column names and data types match. Save both source workbooks in locations that will remain accessible to the workbook containing the combined table.
Append the source tables in Excel Power Query
Use this method to combine rows from both workbooks and update the result through a refresh.
In the workbook where you want Total Expenses, select Data > Get Data > From File > From Workbook. Choose the Project A workbook, select its expense table in Navigator, and select Transform Data.
In Power Query Editor, select Home > New Source > File > Excel workbook. Choose the Project B workbook, select its expense table, and open it in the editor.
Select Home > Append Queries > Append Queries as New. Choose Two tables, select the Project A and Project B queries, and select OK.
Check that the appended columns and data types are correct. Select Home > Close & Load To, choose Table and a worksheet location, then name the resulting table Total Expenses on the Table Design tab.
Save changes in the source workbooks, then right-click the Total Expenses table and select Refresh, or select Data > Refresh All. Rows added within either source Excel table will be included.

Manage Expense Workbooks with WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility, making it easy to move everyday workbook tasks to WPS. Excel Power Query workflows may require continued use of Excel.

Frequently Asked Questions
Will new expense rows appear in the combined table automatically?
New rows added within the source Excel tables are included the next time the query refreshes. Save the source workbooks, then right-click the combined table and select Refresh.
What happens if the source tables have different column names?
Power Query appends columns by name. Different names can create separate columns with blank values, so rename the columns in the source tables or in Power Query Editor before appending.
Can I refresh the combined table when I open the workbook?
Yes. In Excel, open the query's connection properties from Data > Queries & Connections and enable Refresh data when opening the file.
Why can't the query find a source workbook?
The workbook may have been moved, renamed, or made unavailable. In Power Query Editor, check the Source step for the affected query and update the file path.




