Spreadsheet: 797372d1663847702-combining-2-tables-into-1-sorted-by-hour-combining_two_tables_sample-hd-1-1-
Sheet: Blad1

DAYS |  |  | Activities | From | To | Who | Total | Place | Remark | Help Column From empty |  |  | Activities | From | To | Who | Total | Place | Remark | Help Column From empty |  |  | Activities | From | To | Who | Total | Place | Remark
mon | 2022-10-03 00:00:00 | VM | [NAME] | 09:00:00 | 10:00:00 | anneleen | 20 | bib |  |  |  | VM | opleiding inclusie |  |  |  |  |  |  |  |  | VM |  | 09:00:00 | 10:00:00 | anneleen | 20 | bib | 0
 |  |  | klas 2 zoektocht | 10:00:00 | 11:00:00 | anneleen | 23 | bib |  |  |  |  | opleiding media |  |  |  |  |  |  |  |  |  | klas 2 zoektocht | 10:00:00 | 11:00:00 | anneleen | 23 | bib | 0
 |  |  | klas 3 zoektocht | 11:00:00 | 12:00:00 | carolien | 14 | bib |  |  |  |  | boetenbrieven |  |  |  |  |  |  |  |  |  | [NAME] | 10:30:00 | 10:45:00 | carolien | 17 | bib | 0
 |  |  | [NAME] | 10:30:00 | 10:45:00 | carolien | 17 | bib |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | klas 3 zoektocht | 11:00:00 | 12:00:00 | carolien | 14 | bib | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | vergadering de faar | 10:00:00 | 12:00:00 | jan |  | de faar |  |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
 |  | NM | [NAME] | 13:00:00 | 14:00:00 | carolien | 17 | bib |  |  |  | NM | opleiding inclusie |  |  |  |  |  |  |  |  | NM
 |  |  | [NAME] | 14:00:00 | 15:00:00 | anneleen | 28 | bib |  |  |  |  | opleiding media
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | overleg eddy stevens | 14:00:00 | 15:00:00 | jan | 2 | jan
 |  |  |  |  |  |  |  |  |  |  |  | AV | @ppcafé sessie 1 | 19:30:00 | 21:30:00 | karen | 7 | leeszaal |  |  |  | AV
TABLE 1: SCHOOL ACTIVITIES |  |  |  |  |  |  |  |  |  |  |  | TABLE 2: SPECIAL ACTIVITIES |  |  |  |  |  |  |  |  |  | TABLE 3: TABLE 1 & TABLE 2 COMBINED SORTED BY "FROM"
 |  |  |  | RANGES: D4:J14;  D15:J23 |  |  |  |  |  |  |  |  |  |  | RANGES: M4:S14;     M15:S22;        M23:S23;
 | 09:00:00 | 10:00:00 | anneleen | 20 | bib | 0
klas 2 zoektocht | 10:00:00 | 11:00:00 | anneleen | 23 | bib | 0
vergadering de faar | 10:00:00 | 12:00:00 | jan | 0 | de faar | 0
[NAME] | 10:30:00 | 10:45:00 | carolien | 17 | bib | 0
klas 3 zoektocht | 11:00:00 | 12:00:00 | carolien | 14 | bib | 0
[NAME] | 13:00:00 | 14:00:00 | carolien | 17 | bib | 0
[NAME] | 14:00:00 | 15:00:00 | anneleen | 28 | bib | 0
overleg eddy stevens | 14:00:00 | 15:00:00 | jan | 2 | jan | 0
@ppcafé sessie 1 | 19:30:00 | 21:30:00 | karen | 7 | leeszaal | 0
boetenbrieven | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
opleiding inclusie | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
opleiding inclusie | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
opleiding media | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
opleiding media | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
[NAME] | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0
[NAME] | 00:00:00 | 00:00:00 | 0 | 0 | 0 | 0