Hi guys,
We have 3 duplicate cells in SONum column, firstly i have to get the sum of the weights associated with duplicate values that is 58+58+54 and later i have to remove all the duplicate rows and keep the total sum of weight.
The output should look like this:
help me to achieve this