Hi, I’m using Find & Replace excel activity for Finding all the column names in Excel A and Replace them in Excel B.
In Excel A, I want to fetch all the column names horizontally, in Excel B I have the names to be replaced in one single column vertically.
None of my equations is helping me get the work done.
Please help…
Sample_A file has some data with 7 Columns, I have to replace these column names as specified in Header_Data file.
As you can see Header_Data file has 2 columns.
One is the Original (the column names of Sample_A file), the other one is Change To (these will be the new column names for Sample_A file).