Sorting order while transposing the data.

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

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?

Workflow

Input

Reporting

Custom Tools

Date Time

Common Use Cases

Dynamic Processing

Optimization

Expression

Interface Tools

Accepted answers

binu_acs

@Alteryxexpert one way of doing this

CrossTab_11062024.yxmd

All comments

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

Sample.yxmd

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:

Sorting order while transposing the data.yxmd

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.

binu_acs

@Alteryxexpert one way of doing this

CrossTab_11062024.yxmd

Alteryxexpert

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

binu_acs

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703