How to Merge cells and sum values if rows are same

Help Something Else
3

Hi,

Hope the following sample helps you.

image
image737×405 21 KB 

dt = dt.AsEnumerable.GroupBy(Function(r) r("Name").ToString).Select(Function(g) dt.Clone.LoadDataRow({g.Key,g.First()(1),g.First()(2),g.Sum(Function(r) CInt(r("Amount")))},False)).CopyToDataTable

Sample20230520-4L.zip (7.0 KB)

Regards,

1 Like