Summarize values in DataTable

Help
, ,
1

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:

before

to this:

after

Thanks in Advanced :slight_smile:

2

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

Let us know your feedback