VLOOKUP Predicament

[schaferdd]

In the main file I have employee ID and other fields in each respective column.
In the secondary file, I have dates for courses taken that I wish to pull across using VLookup, but the multiple entries for the employee names are reflected in separate rows rather than columns.

Example (In Secondary File)
Jane Smith with Date 1 in column 2, row 1
Jane Smith with Date 2 in column 2, row 2
Jane Smith with Date 3 in column 2, row 3

How can I setup the secondary file such that the multiple dates change to column entries to facilitate a Vlookup back to the main file?

 

[schaferdd]

I realize now that in my initial post I probably did not explain very clearly. Below illustrates what I am attempting to do in order to then perform VLookUp. Any advice would be greatly appreciated.

CURRENT
Employee ID	Course Date
451	04/06/11
451	07/10/13
451	07/22/17
DESIRED
Employee ID	Course Date	Course Date	Course Date
451	04/06/11	07/10/13	07/22/17

<colgroup><col><col span="3"></colgroup><tbody>
</tbody>