Excel Formula Assistance

I am receiving an excel file with thousands of rows of data in it like this:     I need to end up with an Excel file that has one line per employee for each individual pay code or function. ...