I have an excel with almost 190 columns and have observed that there are duplications in columns and I want to rename the duplicate columns.
I tried to read the excel so that I can rename the column but that is throwing column duplication error.
Tried to read execl without headers and change the particular column name as per index but while writing the excel the column headers are not properly working.
Is there a way to read only column names from excel, rename the duplicates and save the column names and this should not change/effect any value in excel.
Please check the excel I am atatching for refernce.In this excel column 25 and column 91 have duplicates and I should rename/change column 91.
Book1.xlsx (13.1 KB)
Can you please provide the flow how to do it
Thanks in Advance.