I have two sets of data that I need to match up. Each set has a common denominator, but there aren't an equal number of records so I can't just sort the columns by those numbers to match them up.
For example, I've got one set like this:
data,111222
data4,223333
and another like this:
data2,111222
data5,223333
I just want a result that looks like the following, matched by the common number:
data,data2
data4,data5
Is there a way to make Excel match two sets of data based on numbers in columns that match and then output required data in the format listed above? Thanks!