How can I get the number sequence as attached? I have the column 'Type' using which I'm trying to derive column 'Number'.
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?
Solved! Go to Solution.
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.
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.
Best,
Fernando Vizcaino
Charlie, thank you so much! There's always so much more to learn from you. Your solution too got me to the answer.