How to find duplicate row in datatable and merge them

Help Studio
, ,
1

Dear Community,

I have a datatable like this:

Col1 Col2 Col3
1 AA 150
2 BB 175
3 CC 100
4 AA 200
5 BB 180

I need to find the rows where an item in Col 1 occurs twice or more often and then merge them like this:

Col1 Col2 Col3
1 AA 350 (150+200)
2 BB 375(175+180)
3 CC 100

Any ideas? Thank You!

2

@Jonathan_Langer
find some starter help here:
GroupBy_Sum_1Col.xaml (7.9 KB)