Remove duplicates from one columns but still have all the other columns in excel

[Krithi1]

Hi,

I have six columns in my excel “A”, “B”, “C”,"D, “E”,“F”

I need to remove duplicates from the column “A” but still have all the six columns as output in the data table. How can I achieve that?

[Anil_G (Anil Gorthi)]

@Krithi1

Try this in assign

Dt = Dt.AsEnumerable.GroupBy(function(x) x(0).ToString).Select(function(x) x.First).CopyToDataTable

Cheers

[Krithi1]

@Anil_G , may I know what is “x” here?

It worked!!

[Anil_G (Anil Gorthi)]

@Krithi1

In place of x you can use anything…it is a lambda expression variable

Cheers