Using pivot tables to group transactions
Posted
by
andreas
on Super User
See other posts from Super User
or by andreas
Published on 2010-10-08T07:25:01Z
Indexed on
2011/11/26
10:02 UTC
Read the original article
Hit count: 203
microsoft-excel
|excel-2007
I have my bank account statement and what I would like to do is group the descriptions of the transactions together with their debit or credit and sum their total. I could then see that, e.g., for ebay.com my total debit was $2000, etc.
Description Debit Credit
A 1
B 1
A 1
B 1
C 1
D 1
A 1
What I want to do is use a pivot table
Description Debit Credit
A 3
B 2
C 1
D 1
I am no able to do that, as I can't group the description and have additional debit and credit columns -- I get them all in rows with blanks.
© Super User or respective owner