Spreadsheet: 763030d1641950779-creating-and-populating-a-fair-rota-use-power-query-to-produce-a-rota-spoonbillsquarepants-
Sheet: Sheet2

Week # | Week of | Mon | Tue | Wed | Thu | Fri | Cover for week |  |  |  |  |  | Creating & populating a fair rota (excelforum.com)
1 | 2022-02-14 00:00:00 |  |  |  |  |  |  |  |  |  | Person | 1 | 3 | 5 | 7 | 9 | 11
2 |  |  |  |  |  |  |  |  |  |  | Person 1 | Mon | Tue | Wed | Thu | Fri | Cover for week
3 |  |  |  |  |  |  |  |  |  |  | Person 2
4 |  |  |  |  |  |  |  |  |  |  | Person 3
5 |  |  |  |  |  |  |  |  |  |  | Person 4
6 |  |  |  |  |  |  |  |  |  |  | Person 5
7 |  |  |  |  |  |  |  |  |  |  | Person 6
8 |  |  |  |  |  |  |  |  |  |  | Person | 2 | 4 | 6 | 8 | 10 | 12
9 |  |  |  |  |  |  |  |  |  |  | Person 7
10 |  |  |  |  |  |  |  |  |  |  | Person 8
11 |  |  |  |  |  |  |  |  |  |  | Person 9
12 |  |  |  |  |  |  |  |  |  |  | Person 10
1 |  |  |  |  |  |  |  |  |  |  | Person 11
2 |  |  |  |  |  |  |  |  |  |  | Person 12
3
4 |  |  |  |  |  |  |  |  |  |  | Person | Week | Day
5 |  |  |  |  |  |  |  |  |  |  | Person 1 | 1 | Mon
6 |  |  |  |  |  |  |  |  |  |  | Person 1 | 3 | Tue
7 |  |  |  |  |  |  |  |  |  |  | Person 1 | 5 | Wed
8 |  |  |  |  |  |  |  |  |  |  | Person 1 | 7 | Thu
9 |  |  |  |  |  |  |  |  |  |  | Person 1 | 9 | Fri
10 |  |  |  |  |  |  |  |  |  |  | Person 1 | 11 | Cover for week
11 |  |  |  |  |  |  |  |  |  |  | Person 2 | 1 | Tue
12 |  |  |  |  |  |  |  |  |  |  | Person 2 | 3 | Wed
1 |  |  |  |  |  |  |  |  |  |  | Person 2 | 5 | Thu
2 |  |  |  |  |  |  |  |  |  |  | Person 2 | 7 | Fri
3 |  |  |  |  |  |  |  |  |  |  | Person 2 | 9 | Cover for week
4 |  |  |  |  |  |  |  |  |  |  | Person 2 | 11 | Mon
5 |  |  |  |  |  |  |  |  |  |  | Person 3 | 1 | Wed
6 |  |  |  |  |  |  |  |  |  |  | Person 3 | 3 | Thu
7 |  |  |  |  |  |  |  |  |  |  | Person 3 | 5 | Fri
8 |  |  |  |  |  |  |  |  |  |  | Person 3 | 7 | Cover for week
9 |  |  |  |  |  |  |  |  |  |  | Person 3 | 9 | Mon
10 |  |  |  |  |  |  |  |  |  |  | Person 3 | 11 | Tue
11 |  |  |  |  |  |  |  |  |  |  | Person 4 | 1 | Thu
12 |  |  |  |  |  |  |  |  |  |  | Person 4 | 3 | Fri
 |  |  |  |  |  |  |  |  |  |  | Person 4 | 5 | Cover for week
 |  |  |  |  |  |  |  |  |  |  | Person 4 | 7 | Mon
 |  |  |  |  |  |  |  |  |  |  | Person 4 | 9 | Tue
 |  |  |  |  |  |  |  |  |  |  | Person 4 | 11 | Wed
 |  |  |  |  |  |  |  |  |  |  | Person 5 | 1 | Fri
 |  |  |  |  |  |  |  |  |  |  | Person 5 | 3 | Cover for week
 |  |  |  |  |  |  |  |  |  |  | Person 5 | 5 | Mon
 |  |  |  |  |  |  |  |  |  |  | Person 5 | 7 | Tue
 |  |  |  |  |  |  |  |  |  |  | Person 5 | 9 | Wed
 |  |  |  |  |  |  |  |  |  |  | Person 5 | 11 | Thu
 |  |  |  |  |  |  |  |  |  |  | Person 6 | 1 | Cover for week
 |  |  |  |  |  |  |  |  |  |  | Person 6 | 3 | Mon
 |  |  |  |  |  |  |  |  |  |  | Person 6 | 5 | Tue
 |  |  |  |  |  |  |  |  |  |  | Person 6 | 7 | Wed
 |  |  |  |  |  |  |  |  |  |  | Person 6 | 9 | Thu
 |  |  |  |  |  |  |  |  |  |  | Person 6 | 11 | Fri
 |  |  |  |  |  |  |  |  |  |  | Person 7 | 2 | Mon
 |  |  |  |  |  |  |  |  |  |  | Person 7 | 4 | Tue
 |  |  |  |  |  |  |  |  |  |  | Person 7 | 6 | Wed
 |  |  |  |  |  |  |  |  |  |  | Person 7 | 8 | Thu
 |  |  |  |  |  |  |  |  |  |  | Person 7 | 10 | Fri
 |  |  |  |  |  |  |  |  |  |  | Person 7 | 12 | Cover for week
 |  |  |  |  |  |  |  |  |  |  | Person 8 | 2 | Tue
 |  |  |  |  |  |  |  |  |  |  | Person 8 | 4 | Wed
 |  |  |  |  |  |  |  |  |  |  | Person 8 | 6 | Thu
 |  |  |  |  |  |  |  |  |  |  | Person 8 | 8 | Fri
 |  |  |  |  |  |  |  |  |  |  | Person 8 | 10 | Cover for week
 |  |  |  |  |  |  |  |  |  |  | Person 8 | 12 | Mon
 |  |  |  |  |  |  |  |  |  |  | Person 9 | 2 | Wed
 |  |  |  |  |  |  |  |  |  |  | Person 9 | 4 | Thu
 |  |  |  |  |  |  |  |  |  |  | Person 9 | 6 | Fri
 |  |  |  |  |  |  |  |  |  |  | Person 9 | 8 | Cover for week
 |  |  |  |  |  |  |  |  |  |  | Person 9 | 10 | Mon
 |  |  |  |  |  |  |  |  |  |  | Person 9 | 12 | Tue
 |  |  |  |  |  |  |  |  |  |  | Person 10 | 2 | Thu
 |  |  |  |  |  |  |  |  |  |  | Person 10 | 4 | Fri
 |  |  |  |  |  |  |  |  |  |  | Person 10 | 6 | Cover for week
 |  |  |  |  |  |  |  |  |  |  | Person 10 | 8 | Mon
 |  |  |  |  |  |  |  |  |  |  | Person 10 | 10 | Tue
 |  |  |  |  |  |  |  |  |  |  | Person 10 | 12 | Wed
 |  |  |  |  |  |  |  |  |  |  | Person 11 | 2 | Fri
 |  |  |  |  |  |  |  |  |  |  | Person 11 | 4 | Cover for week
 |  |  |  |  |  |  |  |  |  |  | Person 11 | 6 | Mon
 |  |  |  |  |  |  |  |  |  |  | Person 11 | 8 | Tue
 |  |  |  |  |  |  |  |  |  |  | Person 11 | 10 | Wed
 |  |  |  |  |  |  |  |  |  |  | Person 11 | 12 | Thu
 |  |  |  |  |  |  |  |  |  |  | Person 12 | 2 | Cover for week
 |  |  |  |  |  |  |  |  |  |  | Person 12 | 4 | Mon
 |  |  |  |  |  |  |  |  |  |  | Person 12 | 6 | Tue
 |  |  |  |  |  |  |  |  |  |  | Person 12 | 8 | Wed
 |  |  |  |  |  |  |  |  |  |  | Person 12 | 10 | Thu
 |  |  |  |  |  |  |  |  |  |  | Person 12 | 12 | Fri