Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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

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 a different column for every unique name in the list.

And sort the entries into those columns.

then I can add them up, etc and clean up errors.

I think from vague memories of the past this is a 'swing table' or 'pivot table' and I spent a bit of time googling and even trying some of the answers I got. But I couldn't make anything work and couldn't grasp the basics of it well enough.

I think new versions of software and such make many google hits out of date and not really useful.

Anyway I think this is a very well known and easy function and if I knew just exactly what to call it I could probably search on the name and get the answer. But I don't know.

Can anyone help, please?

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

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 a different column 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 think thought from vague memories of the past this is would be a 'swing table' or 'pivot table' and I spent a bit of time googling and even trying some of the answers I got. 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 well enough.

I think new versions of software and such make many google hits out of date and not really useful.

Anyway I think this is a very well known and easy function and if I knew just does exactly what to call 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 I could probably search on the name and get the answer. But I don't know.

Can IS the right thing does anyone help, please?know a 'pivot tutor' that would perhaps suit a dunderhead such as myself?

:)