Spreadsheet: 679797d1590633681-using-other-template-my-raw-transpose-using-multi-criteria-lookup-please-help-transpose-multi-criteria-look-up
Sheet: Raw

 | 2020-05-26 00:00:00
 |  |  |  |  | Number of People per Hour
 | Places |  | Total | %GF | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 | Park
RESFDC1 | Park 1 |  |  |  | 2 | 8 | 20 | 3 | 11 | 19 | 12 | 20 | 3 | 14 | 10 | 11 | 17 | 10 | 7 | 17 | 13 | 5 | 12 | 20 | 7 | 6 | 4 | 5
RESFDC2 | Park 2 |  |  |  | 2 | 1 | 1 | 17 | 4 | 14 | 16 | 12 | 10 | 9 | 2 | 6 | 12 | 15 | 5 | 10 | 2 | 2 | 7 | 17 | 18 | 11 | 10 | 9
RESFDC3 | Park 3 |  |  |  | 12 | 6 | 18 | 20 | 17 | 4 | 7 | 10 | 7 | 18 | 1 | 19 | 9 | 15 | 17 | 4 | 8 | 17 | 4 | 3 | 10 | 14 | 5 | 11
 | Hospital
RESFDC1 | Hospital 1 |  |  |  | 6 | 8 | 10 | 16 | 3 | 14 | 11 | 15 | 12 | 6 | 4 | 1 | 15 | 4 | 6 | 19 | 3 | 5 | 14 | 7 | 19 | 2 | 2 | 20
RESFDC2 | Hospital 2 |  |  |  | 2 | 16 | 4 | 7 | 8 | 20 | 12 | 18 | 8 | 6 | 12 | 6 | 8 | 9 | 16 | 11 | 9 | 13 | 15 | 3 | 2 | 18 | 3 | 4
RESFDC3 | Hospital 3 |  |  |  | 6 | 13 | 17 | 13 | 8 | 1 | 5 | 10 | 14 | 19 | 14 | 7 | 6 | 16 | 4 | 15 | 3 | 8 | 6 | 11 | 10 | 3 | 12 | 15
 | 2020-05-27 00:00:00
 |  |  |  |  | Number of People per Hour
 | Places |  | Total | %GF | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 | Park
RESFDC1 | Park 1 |  |  |  | 28 | 22 | 5 | 9 | 30 | 10 | 15 | 17 | 2 | 27 | 29 | 10 | 13 | 26 | 21 | 19 | 22 | 5 | 7 | 15 | 17 | 5 | 29 | 22
RESFDC2 | Park 2 |  |  |  | 7 | 8 | 5 | 1 | 14 | 27 | 23 | 7 | 13 | 13 | 11 | 15 | 8 | 12 | 24 | 20 | 27 | 24 | 7 | 23 | 17 | 30 | 11 | 29
RESFDC3 | Park 3 |  |  |  | 23 | 25 | 23 | 28 | 27 | 1 | 24 | 19 | 11 | 23 | 4 | 23 | 26 | 13 | 10 | 17 | 6 | 24 | 14 | 16 | 12 | 2 | 24 | 20
 | Hospital
RESFDC1 | Hospital 1 |  |  |  | 15 | 14 | 5 | 12 | 16 | 20 | 4 | 28 | 17 | 5 | 30 | 9 | 5 | 23 | 15 | 18 | 8 | 29 | 26 | 17 | 14 | 24 | 9 | 1
RESFDC2 | Hospital 2 |  |  |  | 25 | 4 | 9 | 21 | 22 | 17 | 6 | 9 | 19 | 20 | 14 | 20 | 4 | 1 | 25 | 24 | 15 | 7 | 16 | 24 | 18 | 19 | 23 | 13
RESFDC3 | Hospital 3 |  |  |  | 30 | 27 | 2 | 25 | 15 | 3 | 13 | 16 | 9 | 25 | 19 | 15 | 6 | 1 | 21 | 23 | 10 | 1 | 23 | 18 | 14 | 18 | 22 | 29
 | 2020-05-28 00:00:00
 |  |  |  |  | Number of People per Hour
 | Places |  | Total | %GF | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 | Park
RESFDC1 | Park 1 |  |  |  | 34 | 45 | 27 | 28 | 36 | 40 | 30 | 18 | 9 | 11 | 43 | 13 | 39 | 9 | 45 | 1 | 10 | 27 | 5 | 30 | 42 | 20 | 28 | 32
RESFDC2 | Park 2 |  |  |  | 7 | 29 | 33 | 21 | 29 | 36 | 33 | 19 | 36 | 3 | 37 | 9 | 46 | 10 | 31 | 31 | 28 | 23 | 17 | 30 | 15 | 35 | 39 | 9
RESFDC3 | Park 3 |  |  |  | 20 | 40 | 14 | 13 | 2 | 43 | 2 | 10 | 32 | 6 | 22 | 34 | 4 | 12 | 37 | 28 | 11 | 37 | 39 | 38 | 39 | 13 | 43 | 48
 | Hospital
RESFDC1 | Hospital 1 |  |  |  | 3 | 27 | 25 | 22 | 20 | 38 | 40 | 13 | 29 | 48 | 23 | 29 | 4 | 12 | 29 | 39 | 13 | 18 | 15 | 48 | 19 | 34 | 32 | 28
RESFDC2 | Hospital 2 |  |  |  | 31 | 22 | 13 | 22 | 10 | 19 | 26 | 2 | 1 | 31 | 22 | 50 | 33 | 48 | 46 | 17 | 16 | 37 | 50 | 44 | 39 | 29 | 38 | 27
RESFDC3 | Hospital 3 |  |  |  | 43 | 26 | 43 | 19 | 13 | 45 | 49 | 14 | 23 | 11 | 18 | 33 | 1 | 38 | 19 | 43 | 10 | 48 | 25 | 16 | 26 | 30 | 24 | 44