Combine Data from 2 spreadsheets

I have pulled two reports from our HRIS and exported them into excel and I need to combine the data to the correct person.
- Employee List Report (sheet one): Employee Name, DOB, SSN, etc.
- Dependent List Report (sheet two): Employee Name, Dependents

I would like to move the dependents over to the main report for each employee but since I will be using a mail merge, I need new columns for each dependents. This would be easy if each employee had one dependent but I am stumped when their is two or more.
-Employee List Report Columns: Employee Name, DOB, SSN, Dependent 1, Dependent 2, Dependent 3

I have attached a dummy copy of the report I am working with.