Hi,
I have a file with 3 columns
ABC 3 1
ABC 5 1
XYZ 4 2
DEF 3 2
DEF 4 1
DEF 6 1
MNO 5 5
JKL 3 2
JKL 4 2
PQR 12 1
For each unique entry in column 1 I want to add values in column 2 and column3
o/p
ABC 8 2
XYZ 4 2
DEF 13 4
MNO 5 5
JKL 7 4
Pqr 12 1
Thanks,