Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!

Number sequence

How can I get the number sequence as attached? I have the column 'Type' using which I'm trying to derive column 'Number'.


Number sequence.PNG


I'm not sure if I can get this using Multirow or Tile, yet to try on these. Initial thoughts are heading towards writing a complicated formula but thought to check with the community if there is an easier solution? 


Alteryx Certified Partner
Alteryx Certified Partner

I took a route that used the Tile, Multiple Multi Row Formula, and transformation tools. I used a few more tools than necessary, but it should be easy to follow (browses at key points) and scale. 















Check out the attached example solution and let me know if this works for you.

Alteryx Certified Partner

Hi @cghanshyam ,


One way to achieve that is by creating an additional column only to create that kind of sorting.

Take a look at the attached example and let me know if that works for you.





Fernando Vizcaino

Hi there, 


I think this might be what you're looking for. I got there with with multi-row formulas, a transpose tool and summarize/concatenation. Let me know if you have any questions.


Charlie, thank you so much! There's always so much more to learn from you. Your solution too got me to the answer.