Forum Discussion
Combine the rows of two tables
I have two excel tables in two different excel spreadsheet files. The tables have the same headers. One is labled 'Project A Expenses' and the other 'Project B Expenses'. I want to combine the rows of both these tables into a new excel table called 'Total Expenses'. If possible, the data should also update as new entries are made in the 'Project A Expenses' or Project B Expenses'. Is there any way to do this?
Hi RiaanScorgie
this would be a typical scenario for Power Query. There you would import both source tables into the Power Query editor, append them and load it to your spreadsheet.
Once it's loaded, you can refresh it just with a right-click and you get all new data loaded from both tables.
