Hi, I have bunch of excel files, which i want to collate but these files column names structured with slight variations. e.g
Data Analyst (#1)
I want to replace 1st one to Data Analyst & 2nd to Long Code.
I tried to use Column rename regex, but its not working for me. Appreciate any help on this