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 o...
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.