Power Query Problems

Combine Two Excel Tables Automatically with Power Query

Aamir Naveed AkramAamir Naveed Akram Nov 18, 2026 869 views

Question details

Combine two expense tables from separate Excel workbooks into one refreshable table.

Combine Two Excel Tables Automatically with Power Query
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.
Before you start

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.

Solution 1Recommended

Append the source tables in Excel Power Query

Use this method to combine rows from both workbooks and update the result through a refresh.

1
Import the first table

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.

2
Import the second table

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.

3
Append the queries

Select Home > Append Queries > Append Queries as New. Choose Two tables, select the Project A and Project B queries, and select OK.

4
Check and load the result

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.

5
Refresh after changes

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.

Append the source tables in Excel Power Query
Refreshing the combined table: The result does not update immediately when a source changes. Refresh the query after saving the source workbooks, or enable Refresh data when opening the file in the query's connection properties.
Free Microsoft Office alternative

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.

Review and organize project expense tables in WPS Spreadsheet.Open and save Microsoft Excel XLSX files.Use a familiar spreadsheet interface for everyday workbook tasks.Work with a free, lightweight Office alternative.
microsoft office alternative - wps office

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.