Hello there,
I have the following raw data:
ISBN Elsevier ISBN FILBO 11111 22222 55555 88888 44444 55555 77777 44444 88888 77777 22222 11111
The first column has a special order that I need to maintain. I was wondering if there is any way for excel to identify matches between the First and Second column (the ISBN columns) in order to re-arrange the contents from Column B to F so that they all match Column A order. The result looking like this:
ISBN Elsevier ISBN FILBO 11111 11111 55555 55555 44444 44444 77777 77777 88888 88888 22222 22222
Now, Column B has many more ISBNs than Column A, those remaining that can't be matched shouldn't be removed, but simply left after the matches, like this:
ISBN Elsevier ISBN FILBO 11111 11111 55555 55555 44444 44444 77777 77777 88888 88888 22222 22222 22242 55521 44441
Any suggestion?
the actual sheet has been attached.
Thank you very much for your help.
(note: in Column A, row 141 there is a string, as well as a series of xxxxx in the following row. That should remain intact. It is because I mixed two columns into one. But should remain the same because I need it in that order)
Bookmarks