I have sheets like these:
#sheet1
Name | col1 | col2 | col3
aaa | 1 | 6 | 5
bbb | 5 | 1 | 1
ddd | 4 | 3 | 8
#sheet2
Name | col1 | col2 | col3
aaa | 1 | 3 | 4
bbb | 3 | 2 | 1
ccc | 7 | 5 | 3
And I want the result from both to be:
Name | col1 | col2 | col3
aaa | 2 | 9 | 9
bbb | 8 | 3 | 2
ccc | 7 | 5 | 3
ddd | 4 | 3 | 8
Essentially summing up the values for each column where the name matches.
The layout of each spreadsheet is the same. Names might be in sheet1, sheet2 or both. They are never duplicate in the same sheet.
Most approaches I can find try to concatenate the values (1,2 instead of adding to 3) or count the number of rows each name/ID apprears in. But none of them merge, deduplicate and add values like I need.
