Fix Row Order after Transpose and Crosstab

[tlhoyt]

I had a table where I had to flip flop the rows and columns, which I did successfully with a transpose, following by a crosstab. However, when doing the crosstab, it inadvertently switched the row order on me. 

Below is a view after the transpose:

Below is a view after the crosstab; ChangeinNAV_Bond is now above Sum_PriorQ_NAV:

Does anyone know how to fix this so that ChangeinNAV_Bond remains below Sum_PriorQ_NAV

[binuacs]

@tlhoyt One way of doing this with the batch macro

[tlhoyt]

Hmm. That didn't totally work because I have multiple columns of data that I need:

I need PriorQ_Allocation to be the column headers. After implementing your solution, it appears to be squishing them all into one column:

Any idea how to get the columns to be the PriorQ_Allocation values?

[binuacs]

@tlhoyt I thought you want the output like the one you provided? Can you upload a sample input file and the expected output?

[tlhoyt]

This is what the input looks like:

This is what I want the output to look like:

[binuacs]

@tlhoyt Can you try the attached workflow

[tlhoyt]

When I try to import your workflow, I am unable to replicate that it looks like you are doing:

[binuacs · Accepted solution]

@tlhoyt 

[tlhoyt]

That appears to have worked. Thanks!