Aligning two different sets of data in excel with each other

Here is how to align two different sets of data in excel each set containing multiple rows, but only one common element between the two to use as a 'key'.

This will explain a way to make the data on the left, become the data on the right. We are using "USER ID" as the common value between the two groups

Put each set of data into its own EXEL tab

In my example I want the data in Sheet2 to be put into Sheet1.  
So on Sheet2, select all the data

When you select in, the box in the upper left corner of Excel that normally shows you which cell(s) are select, type in MyData into that box

Here's some Excel Vlookup magic.

Go to Sheet 1 and select the first box to the right of the first row of data that you want matching data to start being displayed.  In my example below i'm putting into C2

and enter this code in

=vlookup($A2,MyData,1,false)

Next put in this into your next column, in my example it will be D2

You will notice

                                        =VLOOKUP($A2,MyData,2,FALSE)

Now do a select and auto fill by selecting the cells you put in the code, and double clicking the autofill dot that appears in the lower right corner of the selection

You should see data fill in like this:

The way the code basically works is
($ColumnWithCommonValueToMatch, DataName, ColumnNumber, code)

=vlookup($a2,MyData,1,false)

=vlookup($a2,MyData,2,false)

=vlookup($A1,MyData,3,false)