Ask Your Question

Calc: How To Break Out A List Into Columns Of Similar Entries?

asked 2019-03-03 03:07:13 +0200

abrogard gravatar image

updated 2019-03-03 22:07:59 +0200

I have a spreadsheet with a downloaded csv banks statement for one year in it.

three columns: date, amount, name

Those 'names' are the different people/accounts that were paid or paid in on those dates.

So I would like the software to make three columns for every unique name in the list.

thisname. amount. date. nextname. amount. date. anothername. amount. date. and so on.....

And sort the entries into those columns.

then I can add them up, totals for each 'name' etc and clean up errors.

I thought from vague memories of the past this would be a 'swing table' or 'pivot table' and I spent a bit of time googling those words and got hits for them and it all seems pretty right, that's what I need.

There's a reply to this question came before I did this edit which says yes, I need a pivot table.

But I couldn't make anything work from those pages I was linked to and couldn't even grasp the basics of how the pivot table worked well enough to judge for myself if it really does exactly what I'm looking for.

Right now I have to hurry up so I'm going to merely sort the list on 'name' and then cut and paste each 'name' section by hand and subtotal them.

But if pivot is not quite the right thing now I've made explicit what I want could some one please tell me?

And if it IS the right thing does anyone know a 'pivot tutor' that would perhaps suit a dunderhead such as myself?


edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-03-03 03:31:14 +0200

robleyd gravatar image

Pivot table is the tool you are looking for; see the Help or the PDF documentation or try an internet search for LibreOffice Pivot Table

If this answer helped you, please accept it by clicking the check mark ✔ to the left and, karma permitting, upvote it. If this resolves your problem, close the question, that will help other people with the same question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-03 03:07:13 +0200

Seen: 39 times

Last updated: Mar 03