If we ignore the requirement of making this data driven, and allow for a manual workflow, then this can be done in as little as two tools:
- Select Records to remove all the headers
- Arrange manually configured to do all the reshaping
I then took on the challenge to make the Arrange tool data driven for this situation, no cross tab or transpose tools, and practiced writing XML to configure the tool in a macro.
Finally, I made a workflow similar to @patrick_digan