Summarize values in DataTable

Hello guys, maybe someone can figure this out. I’ve got a datatable with a column of date followed by Name, Shift Type and Rate.

Now I want to check if the Name has more than one Shift Type(AM) per Date. If yes I want to summarize all the values of rate on the same date in one row

from this:


to this:


Thanks in Advanced :slight_smile:

find starter help here:
GroupBy_3cols_Sum.xaml (7.8 KB)

Let us know your feedback