Sum strings from DT based on condition

Help Studio
1

Hi

based on a DT, how can I sum the amounts based on the main column and still “keep” the orders that the sum is based on.

Maybe this picture better shows what I’m trying to achieve

image

I have looked into BalaRevas activities, but it only sums the rows, it doesn’t give me which rows that has been summed.

2

@Michaeljep
Hi, Try it
dt.AsEnumerable.Sum(Function(x) Convert.ToDouble(x(“Column”).ToString.Split(" ".TocharArray)(1).Trim) )

3

Thank you for the try, it doesn’t quite give me what I need, I need the first dt to be converted to the dt below. So a sum and added columns with the orders summed up.