Spreadsheet: 262986d1378347452-how-to-create-several-roster-by-moving-one-row-each-time-bookroster
Sheet: Sheet3

ROSTER |  |  |  |  |  |  |  |  |  |  | DESIRED RESULT
No. | DATE | SAT. | SUN. | MON | TUE | WED. | THU. | FRI. |  |  | No. | DATE | SAT. | SUN. | MON | TUE | WED. | THU. | FRI.
1 |  | 12 | RRRR | RRRR | 22 | 22 | 22 | 22 |  |  | 2 |  | 15 | 11 | 22 | RRRR | RRRR | 10 | 10
2 |  | 15 | 11 | 22 | RRRR | RRRR | 10 | 10 |  |  | 3 |  | 4 | 1 | 10 | 10 | 10 | RRRR | RRRR
3 |  | 4 | 1 | 10 | 10 | 10 | RRRR | RRRR |  |  | 4 |  | RRRR | RRRR | 8 | 8 | 8 | 8 | 8
4 |  | RRRR | RRRR | 8 | 8 | 8 | 8 | 8 |  |  | 5 |  | 3 | RRRR | RRRR | 1 | 1 | 1 | 1
5 |  | 3 | RRRR | RRRR | 1 | 1 | 1 | 1 |  |  | 6 |  | 1 | 3 | 1 | RRRR | RRRR | 9 | 9
6 |  | 1 | 3 | 1 | RRRR | RRRR | 9 | 9 |  |  | 7 |  | 2 | 5 | 9 | 9 | 9 | RRRR | RRRR
7 |  | 2 | 5 | 9 | 9 | 9 | RRRR | RRRR |  |  | 8 |  | RRRR | RRRR | 17 | 17 | 17 | 17 | 17
8 |  | RRRR | RRRR | 17 | 17 | 17 | 17 | 17 |  |  | 1 |  | 12 | RRRR | RRRR | 22 | 22 | 22 | 22
 |  |  |  |  |  |  |  |  |  |  | No. | DATE | SAT. | SUN. | MON | TUE | WED. | THU. | FRI.
 |  |  |  |  |  |  |  |  |  |  | 3 |  | 4 | 1 | 10 | 10 | 10 | RRRR | RRRR
 |  |  |  |  |  |  |  |  |  |  | 4 |  | RRRR | RRRR | 8 | 8 | 8 | 8 | 8
 |  |  |  |  |  |  |  |  |  |  | 5 |  | 3 | RRRR | RRRR | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | 6 |  | 1 | 3 | 1 | RRRR | RRRR | 9 | 9
 |  |  |  |  |  |  |  |  |  |  | 7 |  | 2 | 5 | 9 | 9 | 9 | RRRR | RRRR
 |  |  |  |  |  |  |  |  |  |  | 8 |  | RRRR | RRRR | 17 | 17 | 17 | 17 | 17
 |  |  |  |  |  |  |  |  |  |  | 1 |  | 12 | RRRR | RRRR | 22 | 22 | 22 | 22
 |  |  |  |  |  |  |  |  |  |  | 2 |  | 15 | 11 | 22 | RRRR | RRRR | 10 | 10
 |  |  |  |  |  |  |  |  |  |  | No. | DATE | SAT. | SUN. | MON | TUE | WED. | THU. | FRI.
 |  |  |  |  |  |  |  |  |  |  | 4 |  | RRRR | RRRR | 8 | 8 | 8 | 8 | 8
 |  |  |  |  |  |  |  |  |  |  | 5 |  | 3 | RRRR | RRRR | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | 6 |  | 1 | 3 | 1 | RRRR | RRRR | 9 | 9
 |  |  |  |  |  |  |  |  |  |  | 7 |  | 2 | 5 | 9 | 9 | 9 | RRRR | RRRR
 |  |  |  |  |  |  |  |  |  |  | 8 |  | RRRR | RRRR | 17 | 17 | 17 | 17 | 17
 |  |  |  |  |  |  |  |  |  |  | 1 |  | 12 | RRRR | RRRR | 22 | 22 | 22 | 22
 |  |  |  |  |  |  |  |  |  |  | 2 |  | 15 | 11 | 22 | RRRR | RRRR | 10 | 10
 |  |  |  |  |  |  |  |  |  |  | 3 |  | 4 | 1 | 10 | 10 | 10 | RRRR | RRRR
 |  |  |  |  |  |  |  |  |  |  | ^
 |  |  |  |  |  |  |  |  |  |  | ^
 |  |  |  |  |  |  |  |  |  |  | ^
 |  |  |  |  |  |  |  |  |  |  | ^
 |  |  |  |  |  |  |  |  |  |  | AND THE LAST ONE WOULD BE
 |  |  |  |  |  |  |  |  |  |  | No. | DATE | SAT. | SUN. | MON | TUE | WED. | THU. | FRI.
 |  |  |  |  |  |  |  |  |  |  | 8 |  | RRRR | RRRR | 17 | 17 | 17 | 17 | 17
 |  |  |  |  |  |  |  |  |  |  | 7 |  | 2 | 5 | 9 | 9 | 9 | RRRR | RRRR
 |  |  |  |  |  |  |  |  |  |  | 6 |  | 1 | 3 | 1 | RRRR | RRRR | 9 | 9
 |  |  |  |  |  |  |  |  |  |  | 5 |  | 3 | RRRR | RRRR | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | 4 |  | RRRR | RRRR | 8 | 8 | 8 | 8 | 8
 |  |  |  |  |  |  |  |  |  |  | 3 |  | 4 | 1 | 10 | 10 | 10 | RRRR | RRRR
 |  |  |  |  |  |  |  |  |  |  | 2 |  | 15 | 11 | 22 | RRRR | RRRR | 10 | 10
 |  |  |  |  |  |  |  |  |  |  | 1 |  | 12 | RRRR | RRRR | 22 | 22 | 22 | 22