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:
and another like this:
I just want a result that looks like the following, matched by the common number:
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!