I have two spreadsheets that have the same employee names. One spreadsheet
has the employee names in column a and overtime hours in column b, and
standard hours in column c. The second spreadsheet has the employee names in
column a and track hours in column b and track overtime hours in column c. I
want to combine these two spreadsheets to where the employees with same name
will have their hours all in one row.


Ex.
Name track_reg track ot
ABRAMS, JAMES 11.50 3
ACKER, EDWARD 8 1
ADAMS, CLIFTON 12.50 2
ADAMS, JAMES 11.50 1
ADAMS, JENNIFER 11.50 3
ALBERSON, OWEN 11.50 1

Name OT ST
ABRAMS, JAMES 0 11.5
ACKER, EDWARD 0 11.5
ADAMS, CLIFTON 5 8
ADAMS, JAMES 0 11.5
ADAMS, JENNIFER 0 11.5
ALBERSON, OWEN 0 11.5


I would like the hours to all in one row for each employee.

Ex:
Name OT ST track_reg track ot
ABRAMS, JAMES 0 11.5 11.50 3