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?

image

Any help will be much appreciated.

Thanks

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

2 Likes

Thanks @ppr

Blockquote

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