Merging Multiple Rows Of Data

I have several worksheets in a single workbook.

I have the following

employee paymethod earningcode earningtype rate hours amount
jane doe H CR R 5.00 80 400.00
jane doe H CO O 7.50 2 15.00
jane doe H HL R 5.00 8 40.00
jane doe H SE R 10.00 10 100.00
john smith H CR R 6.00 10 60.00
...

I need to have

jane doe CR 5.00 80 CO 7.5 15.00 HL 5.00 8 SE 10.00 100.00

I will have multiple employees. Not all employees will have all 4 earning codes (some will only have one, some will have two, and some will have three).