How to remove the duplicate column values in an excel

Hi!

Iam working on an excel, where I have the same column value repeated. I would like to get only the first occurance or remove the rest of the occurance. Any leads pls?

1 Like

Hi @PavithraSundaram

Have you tried this ?

Regards
Balamurugan.S

1 Like

Hello Balamurugan,

Thank you for the suggestion. I used Datatable.DefaultView.ToTable(True,""), and this worked perfectly!

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.