I have the following question:
I have about 2000 records in Column 1 (a code consisting of letters and numbers). In Column 2 I have about 1500 records. All of the records in Column 2 are contained in Column 1. However, since about 500 are missing I cannot sort the equal values next to one another -
How to make it so that Excel matches the values in Column 2 next to the same values in Column 1?
I have attached a word file in order to show a sample of what I need.