Remove duplicates in two columns and keep rest of all the column values

[ppr (Peter Preuss)]

Answered with alternate on the forked / duplicated topic thread:

Remove duplicates in DT for specific columns and keep all column and values

Hi all, need to remove duplicates in two columns (Customer Code,Jurisdiction Name) the attached sheet and also keep rest of all the column values. if I use dt_Inputsheet.DefaultView.ToTable(True,“Customer Code”,“Jurisdiction Name”) syntax I am getting these two columns alone in the output dt . but i need rest of all the columns and corresponding values. [image] Sample.xlsx (6.8 MB)