Hey there,

I have a sample of data below in which there are multiple rows with different hours that all pertain to the same project id and task name.

I am trying to find a way to consolidate the duplicates into a single total for each.

For example, Altos Ohio I want to keep a single line for the Project ID, Task name (May) but have a single hour value of 1.5, rather than the 3 separate entries rows of 0.7, 0.5 and 0.3 as seen in the image.

The reason is due to my import tool, it will import them as 3 separate entries, but the goal end result would be to have the total hours as a single entry so I need to clean up this data before import.