How to Read Excel data with duplicate name and how to handle this?

I want to read whole data with add header. but there is one duplicate name so can’t read whole data because of its showing duplication Error. Now guys please help me to handle this ?

@rahul_pal2
welcome to the forum

find starter help here:
FixDuplicatedColNames.xaml (9.7 KB)

Bro Actually excel columns are also dynamic so how can we find out specific column name??

@rahul_pal2
entire approach works dynamicly anf if any duplicate columname is found it is adding a counter

simulating read range without add headers. We do find the column names in first row:
grafik

after correction the datatable looks like this:
grafik