combine lines, cumulate value

H

helmut

in table, several lines may be identical except for quantity
need code to search for duplicated or trippled or more code and sum th
quantity and delete all but one line which contains summed quantity.

------------------------------------------------------------------
Code Description Quantity other other other
12345 aaaaaaaaa 5 xxx xxx xxx
15432 bbbbbbbbb 1 xxx xxx xxx
12345 aaaaaaaaa 7 xxx xxx xxx
12453 xxxxxxxxxx 2 xxx xxx xxx
12345 aaaaaaaaa 3 xxx xxx xxx
15432 bbbbbbbbb 1 xxx xxx xxx

Result:
------------------------------------------------------------------
Code Description Quantity other other other
12345 aaaaaaaaa 15 xxx xxx xxx
12453 xxxxxxxxxx 2 xxx xxx xxx
15432 bbbbbbbbb 2 xxx xxx xxx

Thanks
Helmu
 
Top