Situations like this sometimes require both Cross Tab and Transpose tools to arrange the data as you'd like. I'm sure there's a way, but I'm having trouble visualizing the exact steps without seeing some sample data. Could you post an image or a workflow with a Text Input of sample data for the Community to get our hands on?
Attached Screenshot as well as workflow for your reference, you dont need to use multiple crosstab, just use Transpose and select all associate column in Data column as shown in image. Hope its work for you.
