Excel - Remove Duplicate and Sum the columns if not keep the row as it is

[KKsekar]

Hi…

I have a excel with some duplicated and not duplicated rows…if the specific row value is duplicated i have to add the sum of the columns and if the row is not duplicated i have to keep the value as it is… The highlighted values i need to take from excel and save it in a new sheet.
I need to create a single row out of the duplicated rows by keep only the start “arrival date” sum of the highlighted columns.

My output to be in this format as attached

Please help me on this…

[caggarwal (Chandan Aggarwal)]

use filter data table activity and first find unique rows,
now again use filter to find duplicate rows,
u can install bala reva package as well, to remove duplicates from excel as well.

Hope that helps