Find duplicate values in data table and do operation as per condition in the same table

Help Studio
3

Hi,

I am having difficulty understanding your suggestion.

But what I did was to try the solution that is provided in the attached link for the other post.

This Post

I am getting output with only the result (Sum) and not the entire Row (with Acc num and Trans ID) like:

Account num, Trans ID, Interest
123456
4567789

Below is my code:

(From d In op_DT
Group d By k=d("Account Num").toString.Trim Into grp=Group
Let sm = grp.Sum(Function (x) CDbl(x.item("Interest").toString.Trim))
Select op_DT.Rows.Add(sm)).CopyToDataTable

How to get all items from the row?