Name Appears Instead Of The Employee ID

SEE ATTACHED FILE

All,

I have a spreadsheet that lists each employees hours for the last 4 pay periods...each is in it's own row I am trying to find out their average.

I am using the subtotal function to average their hours and that works fine. BUT...my boss doesn't want to see 4 rows for each person. He just wants to see one row for each person and when I collapse the rows, it only shows the employee's ID, not the name (because that's what I told the subtotal function to do...add subtotal after every change in employee ID).

name appears instead of the employee ID? That's useless to him because he hasn't memorized all the Employee's IDs.