Fix Row Order after Transpose and Crosstab

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

Transformation

Accepted answers

binu_acs

@tlhoyt

Copy of DynamicFilter_220623.yxmc

Sum_Field_OrderChange_220623_new.yxzp

All comments

binu_acs

@tlhoyt One way of doing this with the batch macro

Sum_Field_OrderChange_220623.yxzp

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?

binu_acs

@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:

binu_acs

@tlhoyt Can you try the attached workflow

Sum_Field_OrderChange_220623.yxmd

tlhoyt

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

binu_acs

@tlhoyt

Copy of DynamicFilter_220623.yxmc

Sum_Field_OrderChange_220623_new.yxzp

tlhoyt

That appears to have worked. Thanks!

Quick Links

This months top contributors

FláviaB 262

JORGE4900 235

caltang 177

DanM 167

IraWatt 157