Multi-Row Formula Tool

[bsolove123]

I have a dataset with the GroupNumber field. I want to create the GroupOrder Field to look like the following:

I need some help configuring the multi-row formula tool. Thanks!

[Pilsner]

Hello @bsolove123 

You could solve this problem with a multi-row however, you might find it easier to use the tile tool, with the Unique method selected.

This will achieve the desired result, except that it starts counting at 1, not 0, so you will need a formula tool to fix this with the following formula.
 

Finally, you may want to drop the original tile column with a select tool to get the following result:

I have attached the workflow below. Please let me know how you get on.

Regards - Pilsner

[Pilsner · Accepted solution]

If you do want to use the multi-row, then the following formula works for me: