You are reading a single comment by @hugo7 and its replies. Click here to read the full conversation.
  • 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.

  • Power query will make the comparison much easier. Load your tables then Power Pivot the two tables using the appropriate common fields..

About

Avatar for hugo7 @hugo7 started