Arranging Data

Hi

I have searched Google for the answer and have not found anything to resolve my problem. I assume there is a simple answer but I have not come across it yet.

We receive a report from other software in excel format. What I need to do is create a method where if i receive the updated data at the end of the week it automatically arranges itself into a spreadsheet I can work with.

I have attached a spreadsheet with what I need. The DATA tab is exactly what the software exports. The Sorted Tab is the minimum requirement so that I can then do a Pivot Table or just work with the information.

The item that has me stumped is that the Employee name is in the same column as the date he / she worked. I need the name in a separate column next to the dates in order to set up an IF THEN formula.

My thoughts are there should be something that can be done that could maybe identify the names and then move them to a new column?

I will need to do this on a weekly basis so am trying to automate the process.

Looking forward to some excel magic...