Pivot tables in excel
- by andreas
Hey GUYS
i have my account bank account statement and what i wanna do is group the description oof transactions together with their debit or credit and sum their total . So that i can see that for ebay.com my total debit was 2000 $ etc...
no the data are like this (btw how do you format this?)
Description Debit Credit
A 1
B 1
A 1
B 1
C 1
D 1
A 1
ETC.... what i wanna do is using a pivot table
Description Debit Credit
A 3
B 2
C 1
D 1
I can seem to be able to do that as i cant group the description and have additional debit and credit columns.....as i get them all in rows with blanks