Group by Column based on sort.

Sarreddy

Hi Team,

I have a fields Volunteer# and Group#, Some of the volunteers have already been assigned a group, but most have not.
Assign the remaining volunteers to groups so that each group has a total of 20 volunteers. Perform the assignment in order by volunteer number. For example, if group 1 needs ten more volunteers, assign the first ten available volunteers to that group. The same process would repeat for group 2, then group 3, etc.

Regards,

Ajith

W-Flow.xlsx

Qiu

@Sarreddy 
I first calculate the necessary remaining volunteer count for each group then use generate rows tool to generate the sequence. then join with oirginal data.

0908-Sarreddy.yxmd