Remove duplicates from excel considering specific columns

[SenzoD (Senzo Dlomo)]

@Teny_Joy, Hi Please check the below:

Removing duplicates in the same column

Hi! I’d like to remove duplicate items in the subsequent rows, but not sure what is the ideal way to do it? I have tried assigning rows = row.Item(0).ToString.Contains(Items) and then using if row 1 = row 2 then duplicate. But if I have 100 rows, it doesn’t seem to be the most feasible way. [image] In this example, I just want to remove James’s row because Apple has already been taken by Sam. Please help!

Remove duplicate rows based on a value from a single data column

I want to remove duplicate rows from a datatable if a particular column1 value is duplicate in other rows. dtOutput=dtOutput.DefaultView.ToTable(True,“column1”) when I try this it removes all the columns as well, but I need the rest of the columns.