A random name splitter destroys the one thing your seating plan, rota or class list depends on: the order. This split group in order with rotation tool keeps every name exactly where you put it, splits the list into equal-ish groups, and builds a rotation schedule so the same groups never repeat week after week.
Paste names in the order that matters — seating order, registration order, rota order. The order is never shuffled. Remainder rule: larger groups first, so 13 names into groups of 4 gives 4, 3, 3, 3, never a group of 1 unless you confirm it.
How to use the split group in order with rotation tool in 3 steps
Step 1 — Paste your names in order. Type or paste one name per line, exactly in the order that matters: seating order, registration order or rota order. The tool never shuffles, so what you type is what you keep.
Step 2 — Choose your split. Pick “by group size” (for example, groups of 4) or “by number of groups” (for example, 4 groups). Then set the number of weeks and the rotation step. A step of 1 moves everyone forward one place each week.
Step 3 — Split, then copy or print. Press Split groups to see your groups and the full rotation table. Use Copy result to paste the schedule into a document, or Print for a paper copy. Clear resets everything.
The remainder rule: larger groups always come first. Thirteen names split into groups of 4 become 4, 3, 3, 3 — never 4, 4, 4, 1. The tool will never leave a group of 1 without asking you to confirm first.
Worked example: 13 names split into groups of 4, rotated for 3 weeks
I pasted 13 names in order and chose “by group size” with a size of 4. I set 3 weeks and a rotation step of 1.
The tool returned groups of 4, 3, 3, 3 — the remainder rule in action. Nobody ended up alone, and every name stayed in its original place.
| Group | Week 1 members |
|---|---|
| Group 1 (4) | Ava, Ben, Cleo, Dan |
| Group 2 (3) | Eli, Fay, Gus |
| Group 3 (3) | Hal, Ivy, Jon |
| Group 4 (3) | Kim, Leo, Mia |
Week 2 shifts the whole list forward by one place and re-splits. Group 1 becomes Ben, Cleo, Dan, Eli, and Ava wraps around to the end of Group 4.
Week 3 shifts two places from the original order. Same names, same group sizes, but fresh combinations — and a schedule you can repeat or extend.
Common mistakes when you split a group in order with rotation
Mistake 1 — Using a random splitter. Randomisers feel fair, but they delete the seating order, registration order or seniority your list was built on. Once shuffled, that information is gone for good.
Mistake 2 — Ignoring the remainder. A naive split of 13 into groups of 4 leaves one person stranded alone as 4, 4, 4, 1. This tool makes the larger groups first, so you get 4, 3, 3, 3 instead.
Mistake 3 — Repeating the same groups every week. Fixed groups go stale, and the same people always end up together. The rotation table shifts the list by your step each week, so mixes stay fresh without extra planning.
More free tools from ToolBrewLab
If you organise lists in spreadsheets, try the count dropdown values across sheets tool. It counts dropdown answers across every tab and reports counts per week.
If you build rotas in Excel, the bulk formula reference locker converts pasted formulas to $A$1, $A1 or A$1 in one go.
FAQs about splitting a group in order with rotation
Why does order matter more than random?
Because the order is the data. A seating plan encodes who sits next to whom, a registration list encodes arrival order, and a rota encodes seniority or fairness. A random split destroys that information permanently, while an in-order split keeps it intact and still gives you fair, balanced groups.
How does the remainder rule work?
When the names do not divide evenly, the extra names go to the earliest groups: 13 names in groups of 4 become 4, 3, 3, 3. Larger groups always come first, and the tool never creates a group of 1 without asking you to confirm.
How does the rotation step work?
Each week the whole list shifts forward by the step, wrapping around at the end, and is split again. With step 1, the person at the top moves to second place in week 2 and third in week 3. A bigger step, such as 2, jumps further each week for faster mixing.
Should I split by group size or by number of groups?
Use group size when the size matters, such as tables that seat 4. Use number of groups when the count matters, such as 3 breakout rooms. Both modes keep your order and use the same larger-groups-first remainder rule.
Does the tool ever shuffle my names?
No, never. There is no shuffle button and no randomisation anywhere in the tool. Your names stay in the exact order you typed them, in week 1 and in every rotation week.