Remove Duplicates



if name and bdate are same i want older data


Not a perfect solution, but if BDate is string this works.I concatenated columns to find duplicates.

dtDuplicates.AsEnumerable().GroupBy(Function(x) x.Field(Of String)(“Name”)+x.Field(Of String)(“BDate”)).Select(Function(y) y.First()).CopyToDataTable()

How can I find all the values in the duplicate column and merge the duplicate rows?


I want to store the duplicated rows in different excel sheet.How could i do that?