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.

[TABLE="width: 331"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD]CURRENT[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Employee ID[/TD]
[TD]Course Date[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]451[/TD]
[TD="align: right"]04/06/11[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]451[/TD]
[TD="align: right"]07/10/13[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]451[/TD]
[TD="align: right"]07/22/17[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]DESIRED[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Employee ID[/TD]
[TD]Course Date[/TD]
[TD]Course Date[/TD]
[TD]Course Date[/TD]
[/TR]
[TR]
[TD="align: right"]451[/TD]
[TD="align: right"]04/06/11[/TD]
[TD="align: right"]07/10/13[/TD]
[TD="align: right"]07/22/17[/TD]
[/TR]
</tbody>[/TABLE]