Reassemble cells to new layout

If Richards Pivot Table is unsuitable,

I would set it up something like this.

This gives you more control and saves you time. It can be set up to count Hours, Shifts, Sick Days, Off Days.

In fact almost anything you have a code count for.