Add numeric columns for duplicate entries according to some key fields

[siddharthsopori]

Hi All,

I have an excel sheet with columns which might have duplicate records when comparing some key fields which I have marked as green. Now the rest of the fields are numeric fields.

I want that columns with numeric values of the duplicate records should get added(total) and only unique entry should remain.

The file is uploaded. Thanks in advance.

 

[siddharthsopori]

I was able to do it via pivot tables. Thanks.