Hello,
I trying to learn how to assign a person to a group ordered by ID number. Please see the example below for better clarity.
I have this dataset
The dataset will be split into 6 groups. Some of the members have already been assigned a group, but some have not. I want to assign the remaining members to groups so that each group has 5 members. I want to perform the assignment in order by ID number. For example, if group 1 needs two more member, assign the first two available member to that group (based on ID number). The same process would repeat for group 2, then group 3, etc
I would highly appreciate it if anyone can provide me with possible solutions to tackle this type of problem.
