This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have attached a workflow which produces the solution you are looking for below, it is a bit of a long workflow to produce the results and I'm sure it could probably be done in fewer steps! As you noted below, it's the combination of a number of cross-tabs and transposes to get to the result.
Let me know if you have any questions on the workflow, or if this works for you.
I have updated the workflow to allow you to reorder the data. Unfortunately it is a bit of a manual process if you are looking to replicate, where I have defined the order using IF statements within the formula tool to create that order.