How to group to sum data and remove duplicated rows?

[LeiCheng]

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

[JoshuaGostick · Accepted solution]

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 solution]

Hi LeiCheng,

Here is a solution to your problem.

I hope this helps!