Crosstab Column Order

[knnwndlm]

Hi SME,

I have a workflow that I plan to convert into a macro, but I'm struggling with getting the header columns to tie to the data correctly. The Name field in the Text Input tool has correct header name that I want except in descending order with the multiple years shown last. In other words, I want the header to show the most recent year first and the total year column last, so if I have 2022, 2023, 2024, and 2024-22, I want to see 2024, 2023, 2022, and then 2024-22 embedded in the header name. This is so that I can tie the data in the correct header name. The workflow below doesn't work because the data and the headed have ascending and descending order, respectively. Could you please help me understand how to fix this so that the header aligns with the data?

Thanks,

kwl

[knnwndlm]

For clarity, the Crosstab output in the middle produces rows 2-3 in the file below, where what I need is on rows 7-8.

[Qiu · Accepted solution]

@knnwndlm 
The CrossTab tool will reorder the column in an accending order so we can utilize this feature by adding some prefix the columns so they can fall into the order we need then remove those prefixes afterwards.

[knnwndlm]

Thank you @Qiu!