Spreadsheet: 869159d1715790402-help-convert-a-table-range-into-another-book2
Sheet: Sheet1

 | [NAME] this |  |  |  |  |  |  |  | Into >>>>> |  |  | THIS
 | shift/day | 1-May | 2-May | 3-May | 4-May | 5-May | 6-May | 7-May |  |  |  | name/day | 2024-05-01 00:00:00 | 2024-05-02 00:00:00 | 2024-05-03 00:00:00 | 2024-05-04 00:00:00 | 2024-05-05 00:00:00 | 2024-05-06 00:00:00 | 2024-05-07 00:00:00 | 2024-05-08 00:00:00 | 2024-05-09 00:00:00 | 2024-05-10 00:00:00 | 2024-05-11 00:00:00 | 2024-05-12 00:00:00 | 2024-05-13 00:00:00 | 2024-05-14 00:00:00 | 2024-05-15 00:00:00 | 2024-05-16 00:00:00 | 2024-05-17 00:00:00 | 2024-05-18 00:00:00 | 2024-05-19 00:00:00 | 2024-05-20 00:00:00 | 2024-05-21 00:00:00
 | empty row | empty row | empty row | empty row | empty row | empty row | empty row | empty row |  |  |  | Nuno |  | 16-24 |  | 0-24
 | 0-8 |  | [NAME] | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] | 0-24
 | 8-16 | [NAME] |  | [NAME] | [NAME] |  |  |  |  |  |  | [NAME] |  | 0-8 |  |  |  |  |  | repeats | repeats | repeats
 | 16-24 |  | Nuno |  |  |  |  |  |  |  |  | [NAME] |  |  | 0-8 ; 8-16 |  |  |  | 0-8
 | 0-12 | George |  |  |  |  | George |  |  |  |  | [NAME] |  |  |  | 8-16 |  |  |  | etc | etc | etc
 | 12-24 |  |  |  |  |  |  |  |  |  |  | [NAME] | 8-16
 | 0-24 | [NAME] |  |  | Nuno |  |  |  |  |  |  | George | 0-12 |  |  |  |  | 0-12
 | empty row | empty row | empty row | empty row | empty row | empty row | empty row | empty row
 | shift/day | 8-May | 9-May | 10-May | 11-May | 12-May | 13-May | 14-May
 | empty row | empty row | empty row | empty row | empty row | empty row | empty row | empty row |  |  |  | (empty rows removed)
 | 0-8 |  | [NAME] | [NAME] |  |  |  | [NAME]
 | 8-16 | [NAME] |  | [NAME] | [NAME] |  |  |  |  |  |  | Shift | Column Labels
 | 16-24 |  | Nuno |  |  |  |  |  |  |  |  | Row Labels | 2024-05-01 00:00:00 | 2024-05-02 00:00:00 | 2024-05-03 00:00:00 | 2024-05-04 00:00:00 | 2024-05-06 00:00:00 | 2024-05-07 00:00:00 | 2024-05-08 00:00:00 | 2024-05-09 00:00:00 | 2024-05-10 00:00:00 | 2024-05-11 00:00:00 | 2024-05-13 00:00:00 | 2024-05-14 00:00:00 | 2024-05-15 00:00:00 | 2024-05-16 00:00:00 | 2024-05-17 00:00:00 | 2024-05-18 00:00:00 | 2024-05-20 00:00:00 | 2024-05-21 00:00:00
 | 0-12 | George |  |  |  |  | George |  |  |  |  | [NAME] | 0-24 |  |  |  |  |  | 0-24 |  |  |  |  |  | 0-24
 | 12-24 |  |  |  |  |  |  |  |  |  |  | [NAME] | 8-16 |  |  |  |  |  | 8-16 |  |  |  |  |  | 8-16
 | 0-24 | [NAME] |  |  | Nuno |  |  |  |  |  |  | George | 0-12 |  |  |  | 0-12 |  | 0-12 |  |  |  | 0-12 |  | 0-12 |  |  |  | 0-12
 | empty row | empty row | empty row | empty row | empty row | empty row | empty row | empty row |  |  |  | [NAME] |  | 0-8 |  |  |  |  |  | 0-8 |  |  |  |  |  | 0-8
 | shift/day | 15-May | 16-May | 17-May | 18-May | 19-May | 20-May | 21-May |  |  |  | [NAME] |  |  |  | 8-16 |  |  |  |  |  | 8-16 |  |  |  |  |  | 8-16
 | empty row | empty row | empty row | empty row | empty row | empty row | empty row | empty row |  |  |  | Nuno |  | 16-24 |  | 0-24 |  |  |  | 16-24 |  | 0-24 |  |  |  | 16-24 |  | 0-24
 | 0-8 |  | [NAME] | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  | 0-8, 8-16 |  |  | 0-8 |  |  | 0-8, 8-16 |  |  | 0-8 |  |  | 0-8, 8-16 |  |  | 0-8
 | 8-16 | [NAME] |  | [NAME] | [NAME]
 | 16-24 |  | Nuno
 | 0-12 | George |  |  |  |  | George
 | 12-24
 | 0-24 | [NAME] |  |  | Nuno