Ask Your Question
0

Spreadsheet Amalgamation with Duplicates

asked 2020-01-07 18:13:49 +0200

lightflowmark gravatar image

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! C:\fakepath\input1.ods C:\fakepath\input2.ods C:\fakepath\output.ods

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2020-01-07 20:51:12 +0200

Jens S gravatar image

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

edit flag offensive delete link more

Comments

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

lightflowmark gravatar imagelightflowmark ( 2020-01-08 09:55:19 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-01-07 18:13:49 +0200

Seen: 33 times

Last updated: Jan 07