I have a list of fruit occurrences like this:
banana
banana
apple
orange
apple
And I want LibreOffice to give me a number of occurrences per fruit, for instance:
banana | 2
apple | 2
orange | 1
How can I do this?
I guess that a pivot table would to require a column full of "1", and it is a pain to create this column.