Cheers all. I'll go through the responses properly later.
I probably should have explained that the main purpose of reformatting it is so I can compare it against another sheet which should have the same information. Then identify the discrepancies, and work out the cause. The final presentation is in the horizontal format.
The hours need to change to days - ie half days, full days, days off with reason code.
It's not a forever peice of work - it's cross referencing while different systems are merged and errors are still being thrown out due to a mix of factors. Usually there will be 2-5 names (out of 60) with mismatches, so once I identify those people it's quite quick to see where the issues are with their info.
Cheers all. I'll go through the responses properly later.
I probably should have explained that the main purpose of reformatting it is so I can compare it against another sheet which should have the same information. Then identify the discrepancies, and work out the cause. The final presentation is in the horizontal format.
The hours need to change to days - ie half days, full days, days off with reason code.
It's not a forever peice of work - it's cross referencing while different systems are merged and errors are still being thrown out due to a mix of factors. Usually there will be 2-5 names (out of 60) with mismatches, so once I identify those people it's quite quick to see where the issues are with their info.