Ask Your Question

How to use consolidate to eliminate duplicate entries and merge their values into one [closed]

asked 2014-10-23 19:45:19 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

For example, I have the following:

A  2
B  3
C  1
A  2
A  3
B  2
D  1

I want to end up with this:

A  7
B  5
C  1
D  1

I tried to follow the example from Excel ( ) thinking it is the same, but all I would get is the same exact initial table just without the column values beyond the first entry. As in:

A  2

Appreciate any directives/suggestions.



edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-03-05 10:35:20.057192


(Edited a bit for better readabilty. Lupp)

Lupp gravatar imageLupp ( 2014-10-23 23:09:29 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2014-10-23 20:37:41 +0200

Lupp gravatar image

updated 2014-10-23 23:03:37 +0200

Best you get the Calc guide from . There you will find a chapter about pivot tables and also one about data analysis containing how to consolidate data. Both tools can deliver what you want.

You might also get a result just playing with the tools. They are (hmmm) "intuitive". (> 'Data' > 'Pivot Table' / 'Consolidate...')

Pivot tables can be later edited (the "layout": definition) - but need explicitly be refreshed.

The results from consolidating can be linked to the source range and will then update automatically - but the definition does not allow editing after creation.

edit flag offensive delete link more

answered 2014-10-24 06:34:26 +0200

karolus gravatar image


The Task is doable in roundabout 15 sec with ~5 Mausclicks, via →Data→Pivottable...

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-10-23 19:45:19 +0200

Seen: 4,028 times

Last updated: Oct 24 '14