Hi all,

I would like to manipulate the columns of 2 different excel file to be the same. For example,

In the first file, I have Apple Orange Mango Starfruit.

In the second file, I have Orange, honeydew, dragonfruit.

I would like to make both columns of both file the same, Apple Orange Mango starfruit honeydew dragonFruit, so that it will be possible to append the files together.

Cheers,
Jack