Using pivot tables to group transactions
- by andreas
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.