This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
Key for me on this one was to save myself some unnecessary re-ordering by reversing the string at the beginning. Then splitting out the digits, ordering by ID, then deriving the ending column number and pivoting the columns.
I used a few more tools, because I wanted it to be totally dynamic (able to handle numbers of any reasonable width, number of decimal places, etc.)
Of course, the tricky part is that the crosstab tool sorts columns alphabetically. I was expecting it to sort 1, 10, 11, 12, 2, 3, etc., so I went through the extra step of padding the column headers and then removing the padding later. However, I learned from @patrick_digan's solution that crosstab sorts the columns numerically if the field selected for the column header is a numeric type!