I used a few extra tools to assign record and order numbers to make sure the data was transformed exactly as requested. When string fields are used to transpose, they are often sorted to alphabetic order so assigning numeric order fields are a safe way to go.
Check out the attached solution and let me know if you have any questions.
I have a similar question with a slightly different output. I want to transpose the attached data and I need it to look like the Output spreadsheet.
I used the workflow developed by CharlieS but it needs a change which I cannot figure out. Any chance someone could make this work? I could use the Select tool and do the renaming of the columns, but my data constantly changes and I don't want to be changing the names in the Select tool everytime I add more data.
The workflow that I provided to the original poster should work for you with 1 tweak, because you are grouping by two fields I created a single field to join the two together to use as a header. Please see the attached workflow.