Sorting export Data

Hi All

I have an export from a system that I need to sort so that it is easier to work with.

I would like to do this through VBA. I have attached a copy of a sample file. Sheet 1 is how the report will export. Sheet 2 is the ideal output of the report.

Also I have a couple of considerations to take in to account and this is where I am getting stuck:

1 - The team size of the team will change depending on which team I have exported the data for. This would mean that the ranges would need to be dynamic. Employee will always appear to the left of a date and above the peoples names.

2 - The Labour Number is not an individual reference instead this links people back to a Department & Area

3 - any field which contains data like "M 8:00" would need to be changed to something such as "MAT/PAT"

That should pretty much cover it all but if you do have any questions please feel free to drop me a line I will be more than happy to help

Thank you in advance for any support that you may be able to give

D