Add Same customer numbers in Duplicate id's remove that duplicate rows

[nb_s]

Hii,

                                      i have duplicate id's and add customer numbers and write in another column next delete one duplicate rows

like this

[nb_s]

output like this

[Shiva_Nikhil]

@nb_s

when we are removing duplicates with respect to “id column"

dataTable new_dt =
old_dt.AsEnumerable().GroupBy(Function(i) i.Field(Of String)(“id”)).Select(Function(g) g.First).CopyToDataTable

Cheers

[nb_s]

i want add(+) custmer numbers in duplicate id’s

like this

[Shiva_Nikhil]

@nb_s

dt.AsEnumerable.GroupBy(function(r) r(0).tostring).Select(function(g) dt.Clone.LoadDataRow(g.First().ItemArray.Take(4).Concat({g.Sum(function(a) Cdbl(a(1)))}).ToArray,True)).copytodatatable

cheers