convert multiple employee records to one record per employee

This is what my file currently looks like. Multiple records for each employee.

Employee ID Employee First Name Employee Last Name Bargain Unit Absence Reason Initial Balance
1000244 Barb Wire ESPA 260 ILL 12
1000244 Barb Wire ESPA 260 VACATION 22
1000244 Barb Wire ESPA 260 PERSONAL 4
1000177 Linda Savage ESPA 260 ILL 12
1000177 Linda Savage ESPA 260 VACATION 11
1000177 Linda Savage ESPA 260 PERSONAL 4
1000177 Linda Savage ESPA 260 SICK BANK 0

This is what I would like it to look like. One record for each employee.

Employee ID Employee First Name Employee Last Name Bargain Unit ILL VACATION PERSONAL SICK BANK
1000244 Barb Wire ESPA 260 12 22 4
1000177 Linda Savage ESPA 260 12 11 4 0

Any help is appreciated.