carton_no itemno location_code quantity
AD/00005/ER FLOWER2 BLOCK 4 6
AD/00007/ER FLOWER2 BLOCK 4 1
AD/00003/ER FLOWER BLOCK 4 4
AD/00004/ER FLOWER BLOCK 4 4
AD/00005/ER FLOWER BLOCK 4 4
AD/00003/ER FLOWER2 BLOCK 4 6
AD/00003/ER FLOWER BLOCK2 3
AD/00005/ER FLOWER BLOCK 4 4
I need output:
carton_no itemno location_code quantity
AD/00003/ER FLOWER BLOCK 4 7
AD/00003/ER FLOWER2 BLOCK 4 6
AD/00004/ER FLOWER BLOCK 4 4
AD/00005/ER FLOWER BLOCK 4 8
AD/00005/ER FLOWER2 BLOCK 4 6
AD/00007/ER FLOWER2 BLOCK 4 1
Thanks in Advance