Need Help with Reformatting/Organizing ADP Timecard Reports

Hello hello! Hope you're having a wondermazing day, whomever might be reading this.

The long and short of it is thusly-- I've got some ADP timecard reports in Excel (that were likely just ripped from a PDF) that're formatted in such a way that they're impossible to play with, filter for specific information, etc. I'd like to fix this. Maybe with some sort of VSTACK shenanigans or the like? Some sort of spillable-formula? I've only barely scratched the surface of what's possible with this program, so I'm not even really sure where to start. It'd be best if I had some formula or other method of automating this process.

Here is what they currently look like (sensitive information obviously changed/removed):

atcja1.png

Here's what I'd like them to look like:

atcja2.png

Attached to this post is a workbook-- I did the first 'block' of entries manually, as an example. Also, if anyone's got an idea but there is some sort of 'manual' or 'by hand' tweaking I have to do first to make some automatic solution work, I'm open to that, too. Really, I'm open to any help at all!

Thanks in advance.