Hello. I have 14 tables (Balance Sheets) that I am trying to merge into one table. Not all have the same accounts (row tittles). So, they do not all match up. Is there an easy way to merge all 14 into 1 table and all the rows (and their related amounts) match up perfectly? Thanks! Mike
Taking a guess at what you are trying to do, you could consider something like this:
In the individual balance sheet tables add a column and enter the entity name in each cell.
Copy-paste the data in the individual balances sheets one-by-one into a "combined" table.
Set up a new "Merged" balance sheet table with entity names listed across the top row and account titles down the first column.
Enter the following formula in B2 and fill or copy to the right and down in that table:
=SUMIFS(Combined::$C,Combined::$B,$A2,Combined::$A,B$1)
If your region uses , as a decimal separator then instead enter:
=SUMIFS(Combined::$C;Combined::$B;$A2;Combined::$A;B$1)
SG
Taking a guess at what you are trying to do, you could consider something like this:
In the individual balance sheet tables add a column and enter the entity name in each cell.
Copy-paste the data in the individual balances sheets one-by-one into a "combined" table.
Set up a new "Merged" balance sheet table with entity names listed across the top row and account titles down the first column.
Enter the following formula in B2 and fill or copy to the right and down in that table:
=SUMIFS(Combined::$C,Combined::$B,$A2,Combined::$A,B$1)
If your region uses , as a decimal separator then instead enter:
=SUMIFS(Combined::$C;Combined::$B;$A2;Combined::$A;B$1)
SG
In what way are they to be merged? Do the 14 tables each consist of the titles in one column and a single column of numbers in another? Will the merged table will have 14 columns plus a column for the "titles"?
How many rows (row titles) are in one of these 14 tables? I ask this second question because if not an excessive number of rows it might be easiest to do a lot of this manually. It may still take a lot of manual work in any case.
Merging into a Numbers Table
