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

[Qiu · Accepted solution]

@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.

[Qiu]

@Sarreddy 
Thank you for accepting my idea.
I am thinking to submit this one as an idea for weekly challenge. can you approve that?