big project need to add and delete

[ksnapp]

here is a sample of my data:

client name disctirpion #
client 1 Orders 7
Deliveries 1
Item 4
Payments 4
Payments 0
TOTAL TRANSACTIONS 9
client 2 Orders 69
Deliveries 8
Item 15
Payments 6
Payments 56
Item 1
Deliveries 1
Payments 2
Payments 3
Payments 1
TOTAL TRANSACTIONS 86
client 3 Orders 2710
Deliveries 45
Item 505
Payments 21
TOTAL TRANSACTIONS 571
client 4 Orders 50
Orders 74
Deliveries 1
Item 1
Payments 9
Payments 2
TOTAL TRANSACTIONS 13
client 5 Orders 15
Deliveries 20
Item 72
Payments 1
Deliveries 0
TOTAL TRANSACTIONS 93

I have tried to skin this cat several different ways and can't do i
correctly.

What I need to accomplish is this:

for each client I need to have only one of each discription If ther
is more than one i need to show the sum of the values in the firs
entry and then delete any others that follow.

Any Ideas would be greatly appreciate

 

[ksnapp]

that didn't post right
i'll try again

 

[ksnapp]

client name tran type number
client 1 Acct 34
contacts 27
orders 91
orders 9
orders 0
orders 0
TOTAL TRANSACTIONS 127
client 2 Acct 25
contacts 3
orders 11
orders 1
TOTAL TRANSACTIONS 15
client 3 Acct 103
contacts 134
orders 406
orders 73
TOTAL TRANSACTIONS 613
client 4 Acct 87
contacts 58
orders 167
orders 6
orders 120
orders 55
TOTAL TRANSACTIONS 406
client 5 Acct 1,749
contacts 3
orders 35
orders 0
TOTAL TRANSACTIONS 38