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 (https://www.youtube.com/watch?v=IGaq_biQ1B8) 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
...3
...1
...2
...3
...2
...1
Appreciate any directives/suggestions.
Thanks,
T
(Edited a bit for better readabilty. Lupp)
Best you get the Calc guide from http://www.libreoffice.org/get-help/documentation/. 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.
Hallo
The Task is doable in roundabout 15 sec with ~5 Mausclicks, via →Data→Pivottable…