How to read excel file that is having same column names?
I have a excel file that is downloaded from sap and it has same column names in different fields as a result i’m unable to read the excel to studio as same column exist. Is there any way we can read the excel
Material Material Material Nha Nha
Group Type Dns status.
As there are multiple columns with same name read range is not working !! I need to filter the contents in Material type and copy it to another sheet.
The file is huge and formatting is not possible at start.
Any code or ideas will help.
Thank you in Advance.