Need to be able to indentify each row that belongs to that specific user

I have a file that is imported from the district's server. I do not have a choice on how it is formatted so it causes problems for me to upload to my database. How can I get the staff members name associated with each of the row that belongs to them For example.

Smith, Paul has 6 rows assigned to his name and StaffID but it is setup in a block. I want to be able to import each of his rows identified to him.

Please Login or Register  to view this content.

So under the Staff ID and name I want it to show on each row the staff ID and name. This will help me upload to my database much quicker and without error. Hope this makes sense. Thank you.

I attached a sample file that is downloaded from their database. TeacherList_ForumExampleDec12012.xlsx