I have three columns of data. I need to match up the part numbers in column E to the part numbers in Column F. Column H relates to Column F and must be kept together with the data in column F. There will be some part numbers that do not have a match. Those need to be sorted at the bottom when finished.
For Example:
Column E Column F Column H
100247 100247 82.10
100309 100313 55.10
100319 100319 57.80
100378 100341 11.90
101577 100378 24.30
I need it to look like:
Column E Column F Column H
100247 100247 82.10
100309
100319 100319 57.80
100378 100378 24.30
101577
100313 55.10
Not sure where to start on this to match up columns with out losing Column H in the process.
Bookmarks