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?