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.