How to remove duplicate values

[lrtetala (Lakshman Reddy)]

@Chippy_Kolot

Hi, here I’m attaching a sample excel, Having headers as name, phone no and address, the main intention is to remove duplicate rows and right in to sheet 2,but address is different, then how can i proceed this.

Hi @Chippy_Kolot

Try this

DT1.AsEnumerable() _
    .GroupBy(Function(row) New With { _
        Key .Name = row.Field(Of String)("Name"), _
        Key .Phno = row.Field(Of Double)("Phno") _
    }) _
    .Select(Function(Group) Group.First()) _
    .CopyToDataTable()

Test (6).xlsx (9.2 KB)

Regards,