How to group to sum data and remove duplicated rows?

Question

It looks easy, but I really don't know how to deal with this. first sum the IDs hrs, then remove duplicated date....

Group sum.xlsx

JoshuaGostick · Accepted Answer

Hi @LeiCheng,

The workflow attached should do the trick for you. Let me know if you have any questions about it.

Thanks,

Josh

Dazzerman · Accepted Answer

Hi LeiCheng,

Here is a solution to your problem.

I hope this helps!