I have two different excel file. I have to make the columns headers equal.In first file i have column names nd have some value in it.In second file i have different column names but have same value as 1st file have.but some column have sane column name in both the files.
So i wanted the to make the bot which will make the column headers as equal.
For example i have column name like this in 1st file
Fruits. Man. animals. Data.
Nd now second file have column name like this
Veg. Humans. Animals. Info
Nd both these file have some value in it but fruits also have same value as in Veg column. And man also have same value as Humans have like this for others columns also.
So i wanted to make them equal.like this two file column name is same
Note: these two file column heading is starting somewhere in between the sheet.Not just from the starting
Experts plss help