Spreadsheet: 736066d1623336557-id-like-to-get-data-from-one-worksheet-to-another-without-the-blanks-using-a-formula-test-excel-without-blank-cells
Sheet: Sheet1

Volgnummer | Periode | Weeknr | Tdatum | Opleiding | [NAME] | Omschrijving | Van | Tot | Lokatie | E_Lokatie | Soort | Aantal deelnemers | Verdeling
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 09:00:00 | 10:30:00 | ZP07/A1.110 | U103, U101 | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 11:00:00 | 12:30:00 | ZP07/A1.110 | U103, U101 | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 12:30:00 | 14:30:00 | ZP23/C201 |  | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | HanzePlaza |  | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 17:00:00 | 20:00:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 20:00:00 | 20:45:00 | Thuis |  | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis |  | Test | Test | Test
Test | P4 | Test | 2021-06-07 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis |  | Test | Test | Test
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 08:30:00 | 10:00:00 | Energy Barn |  | Test | Test | Test
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis |  | Test | Test | Test
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 11:30:00 | 13:30:00 | Energy Barn |  | Test | Test | Test
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 11:30:00 | 13:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 11:30:00 | 13:00:00 | Stadskerk |  | Test | Test | Test
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 12:30:00 | 14:30:00 | ZP23/J009 | ZP23/J011 | Test | Test | Test
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 12:30:00 | 14:30:00 | ZP23/J009 | ZP23/J011 | Test | Test | Test
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 12:30:00 | 14:30:00 | ZP23/J009 | ZP23/J011 | Test | Test | Test
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 13:00:00 | 21:15:00 | ZP07/F202 | ZP23/B202, C201, ZP11: A120, B138, A133, B120, ZP09: D112, D219 | Test | Test | Test
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 14:30:00 | 16:00:00 | ZP07/A0.100 | Energy Barn, ZP07/A0.077, A0.069, A0.031 | Test | Test | Test
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 17:00:00 | 19:30:00 | Hanzeplaza |  | Test | Test | Test
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 17:00:00 | 18:30:00 | Thuis |  | Test | Test | Test
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-08 00:00:00 | Test | Test | Test | 19:00:00 | 20:30:00 | Energy Barn |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 08:30:00 | 11:00:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 11:30:00 | 13:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | Energy Barn | ZP07/A1.110 | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 14:30:00 | 16:00:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | HanzePlaza |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 17:00:00 | 18:00:00 | Thuis |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 17:00:00 | 18:00:00 | Thuis |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 17:00:00 | 20:00:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 17:00:00 | 20:00:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 17:00:00 | 19:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 17:00:00 | 19:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-09 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | ZP07/A1.110 |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 08:30:00 | 11:00:00 | ZP09/D232 | ZP09/D126, ZP07/A2.111 | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 08:30:00 | 11:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 09:30:00 | 11:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 11:30:00 | 13:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | HanzePlaza |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 17:00:00 | 20:00:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 17:00:00 | 19:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 18:00:00 | 19:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 18:30:00 | 20:30:00 | Energy Barn |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-10 00:00:00 | Test | Test | Test | 20:00:00 | 21:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-11 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Energy Barn |  | Test | Test | Test
Test | P4 | Test | 2021-06-11 00:00:00 | Test | Test | Test | 08:30:00 | 11:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-11 00:00:00 | Test | Test | Test | 08:30:00 | 10:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-11 00:00:00 | Test | Test | Test | 09:00:00 | 10:30:00 | ZP07/A1.110 | ZP07/U103, U101 | Test | Test | Test
Test | P4 | Test | 2021-06-11 00:00:00 | Test | Test | Test | 10:30:00 | 13:30:00 | ZP11/A120 |  | Test | Test | Test
Test | P4 | Test | 2021-06-11 00:00:00 | Test | Test | Test | 11:00:00 | 12:30:00 | ZP07/A1.110 | ZP07/U103, U101 | Test | Test | Test
Test | P4 | Test | 2021-06-11 00:00:00 | Test | Test | Test | 11:30:00 | 13:30:00 | Hanzeplaza |  | Test | Test | Test
Test | P4 | Test | 2021-06-11 00:00:00 | Test | Test | Test | 14:30:00 | 16:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-11 00:00:00 | Test | Test | Test | 14:30:00 | 15:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-11 00:00:00 | Test | Test | Test | 14:30:00 | 15:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-11 00:00:00 | Test | Test | Test | 14:30:00 | 15:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-11 00:00:00 | Test | Test | Test | 14:30:00 | 15:30:00 | Thuis OS |  | Test | Test | Test
Test | P4 | Test | 2021-06-11 00:00:00 | Test | Test | Test | 14:30:00 | 15:30:00 | ZP09/D232 | ZP07/A1.110 | Test | Test | Test
Test | P4 | Test | 2021-06-11 00:00:00 | Test | Test | Test | 17:00:00 | 18:30:00 | ZP09/D232 | ZP07/A1.110, ZP11/B138, ZP11/A133, ZP11/A120, ZP11/B120 | Test | Test | Test