Spreadsheet Amalgamation with Duplicates

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

You shall use the function from Menu: Data - Consolidation

  1. select the area of each sheet you want to consolidate and add in to the dialogbox in ‘Consolidationareas’
  2. Mark both ‘Rowlabels’ and ‘Columnlabels’
  3. Create a new sheet for the result

Jens

UPDATE: on careful re-reading, this answer does exactly what I wanted it to. Many thanks, Jens!