Hi,
I’m trying to amalgamate data from two spreadsheets. The spreadsheets contain two columns: name and amount. The names overlap - so spreadsheet 1 has names a,b and d and spreadsheet 2 has names a,b,c and e. I want to combine these into a single spreadsheet containing names a,b,c,d,e - with the correct amounts. I’ve attached an example to show what I mean.
Is there a sensible means of doing this using Calc? I appreciate that a DB is the correct method for this kind of data manipulation, but this is what I’ve got.
Any help really appreciated!
input1.ods
input2.ods
output.ods