Reformat Spreadsheet

Acct Name Tran Orig Adj Fin Type
123456 PERSON A 22.5 2.5 2.5 2.5 ATM
123456 PERSON A 2 2 2 2 SC
121212 PERSON B 2 2 2 2 SC
654321 PERSON C 123 3 3 3 ATM
654321 PERSON C 42 2 2 2 ATM
654321 PERSON C 41.75 1.75 1.75 1.75 ATM
654321 PERSON C 2 2 2 2 SC
654321 PERSON C 2 2 2 2 SC

How can I take the above sheet and put it into the following format:

Acct Name Tran ATM SC TotFee
123456 PERSON A 24.5 2.5 2 4.5
121212 PERSON B 2 0 2 2
654321 PERSON C 210.75 6.75 4 10.75

Thanks for your help.