Read Range - Get Duplicate Columns

Hi all,

I have a bot that needs to read a large Excel file, with multiple sheets and then merge them into another Excel, to a single sheet.
In will have duplicates in that file, either in the same sheet or in different ones and can’t get over the below error.
Any thought how to handle this error and get all columns/rows moved into a single sheet?


Any help will be much appreciated.


give a try on untick add headers and let use autogenerated column names


Thanks @ppr


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