How to remove duplicates in an excel

Hi every one,
I have an excel file which contains a duplicate column. In the output i want excel file without duplicate column.
I’m attaching a sample excel file for your understanding. TestData.xlsx (9.9 KB)

Your help is much appreciated. cheers


If you know the index of the column which is duplicate and if you want to delete it you can use
activity Remove Data column, specific which index and from which datatable you want to delete the column.

While using read range uncheck add headers option,

Hi @sridhar1516,

This would be helpful for you.