In a big data sometimes I have identical rows (maybe the 'Quantity' column has different value). I would like to merge them into one and add the quantities together. I have to use B and C (I need both) to find out if these rows are identical.
For example:
A1=date B1=111222 C1=ABCD ... and G1=quantity (1)
A2=date B2=111222 C2=ABC ... and G2=quantity (1)
A3=date B3=111222 C3=ABCD ... and G3=quantity (2)
A4=date B4=111222 C4=ABCD ... and G4=quantity (1)
A5=date B5=222111 C4=ABCD ... and G5=quantity (1)
And I would like to have my final date look like this:
A1=date B1=111222 C1=ABCD ... and G1=quantity (4)
A2=date B2=111222 C2=ABC ... and G2=quantity (1)
A3=date B5=222111 C4=ABCD ... and G5=quantity (1)
Thanks in advance!
For example:
A1=date B1=111222 C1=ABCD ... and G1=quantity (1)
A2=date B2=111222 C2=ABC ... and G2=quantity (1)
A3=date B3=111222 C3=ABCD ... and G3=quantity (2)
A4=date B4=111222 C4=ABCD ... and G4=quantity (1)
A5=date B5=222111 C4=ABCD ... and G5=quantity (1)
And I would like to have my final date look like this:
A1=date B1=111222 C1=ABCD ... and G1=quantity (4)
A2=date B2=111222 C2=ABC ... and G2=quantity (1)
A3=date B5=222111 C4=ABCD ... and G5=quantity (1)
Thanks in advance!