Group data by one column then sort another column with an ascending loop

[JordanJ]

Hi all,

Is there a way to group data by one column's values, and then have another one (or two) columns sort in ascending order then start the sort over when a certain value is reached in the second column?

For example, I want to have issue age grouped by age, and then I want to have duration and issue age sorted in ascending order. Once attained age reaches its highest value (120) I want the loop to start over.

Issue Age	Duration	Attained Age
59	1	59
59	2	60
59	3	61
59	4	62
59	5	63
.	.	.
.	.	.
.	.	.
59	62	120
60	0	60
60	1	61
60	2	62

I've tried a few things with summarize tools, multi-row formulas, sorting tools, etc. and haven't been able to figure it out.

Thanks!

[geraldo]

HI,

Have you tried 3 group by to verify the result?

[]

[DiganP · Accepted solution]

@JordanJ  Attached is the workflow. I just sorted by issue age, duration and attained age then use the unique tool to get rid of duplicates ending with the multi-row formula tool to get the counter. Is this what you are looking for?

[JordanJ]

Thanks @DiganP, that worked perfectly!