How to remove duplicate from excel

Help
2

Hi @cheersrpa

See below options

if you want to apply this or particular columns you can do it like this

DataTable distinctTable = dtRows.DefaultView.ToTable(true, "column1","column2");

Thanks,
Prankur

2 Likes