Add column values of each Id in data table (1st row of each id)

[Yoichi]

Hi,

How about the following sample?

dt.AsEnumerable().GroupBy(Function(r) r("Id").ToString).ToList.ForEach(Sub(g) 
    g.First().Item("A")=g.Sum(Function(r) CDbl(r("A").ToString))
    g.First().Item("B")=g.Sum(Function(r) CDbl(r("B").ToString))
    g.First().Item("C")=g.Sum(Function(r) CDbl(r("C").ToString))
    g.First().Item("D")=g.Sum(Function(r) CDbl(r("D").ToString))
End Sub)

Sample20220921-2.zip (8.8 KB)

Regards,