Sorting order while transposing the data.

[Alteryxexpert]

I Have the below data,

Business	Date	Value
IT	Jan-24	1223
IT	Jan-25	156
IT	Jan-26	3123
IT	Feb-24	656
IT	Feb-25	1313
IT	Feb-26	66
IT	Mar-24	1646
IT	Mar-25	3323232
IT	Mar-26	41644
IT	Apr-24	56526
IT	Apr-25	2263
IT	Apr-26	1236232

Data Available for all the 12 months.

When I'm Transposing it this is becoming like below,

Business

Apr_24

Apr_25

Apr_26

Aug_24

Aug_25

Aug_26

Feb_24

Feb_25

Feb_26

Jan_24

Jan_25

Jan_26

IT

1223

656

1646

But i Want the output as below.

Business	Jan-24	Feb-24	Mar-24	Apr-24	Jan-25	Feb-25	Mar-25	Apr-25	Jan-26	Feb-26	Mar-26	Apr-26
IT	1223	656	1646	56526	1223	656	1646	56526	1223	656	1646	565

How to Achieve this?

[griffinwelsh]

Update: I missed the part about the sort order. You can assign a record id and then use a dynamic rename to get the desired sort order. See the attached workflow

 

[Alteryxexpert]

I'm Using Crosstab only, the output of the crosstab is coming like this,

Business	Apr_24	Apr_25	Apr_26	Feb_24	Feb_25	Feb_26	Jan_24	Jan_25	Jan_26	Mar_24	Mar_25	Mar_26
IT	56526	2263	1236232	656	1313	66	1223	156	3123	1646	3323232	41644

Whereas it should be Jan-24,Feb-24,Mar-24,Jan-25,Feb-25,Mar-25,Jan-26,Feb-26,Mar-26

[alexnajm]

Because the Crosstab puts it in alphabetical order, you'll need to use a Formula tool to add something to the header column so it sorts correctly! Workflow attached:

[griffinwelsh]

Sorry I missed the sort requirement. Recommend using Alex's solution

[Alteryxexpert]

Adding something to the header will the change the Structure of the report. Is there any other way?

[alexnajm]

I am not sure I agree with that @Alteryxexpert - it is temporarily added to aid you and the Crosstab tool to order correctly, then removed with the Dynamic Rename to its original format.

[binuacs · Accepted solution]

@Alteryxexpert one way of doing this

[Alteryxexpert]

@binuacs Is there a way to populate total under each column? Which should be dynamic if new months are added in future. 

A Summarize won't pick the new data when used

[binuacs]

@Alteryxexpert use the row total option in the cross tab tool