Manipulating two different columns to be the same

[Jackcell]

Hi all,

I am trying to compare two different headers from 2 different excel files.

For example,

for the 1st excel file, I have Apple, Orange, Pear, honeydew

For the 2nd excel file, I have Orange dragonFruit, starfruit, pear, Apple.

I need to manipulate the columns till it becomes identical.

for e.g, the final column would be Apple, Orange, Pear, Dragonfruit, starfruit, honeydew\

Cheers,
Jackson