Pivot tables in excel

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/01/08 21:55 UTC
Read the original article Hit count: 149

Filed under:
|

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

© Super User or respective owner

Related posts about excel

Related posts about excel-2007