Spreadsheet: 675273d1588228991-extract-data-from-multiple-columns-and-rows-to-make-a-single-list-revision-ward-list
Sheet: WARD LIST

 | WEST WING |  |  |  |  |  |  |  |  |  |  |  |  |  | WEST WING |  |  |  |  |  |  |  |  |  |  |  |  |  | NORTH WING |  |  |  |  |  |  |  |  |  |  |  |  |  | EAST WING
 | WARD | ROOM | UNIT | MALE / FEMALE | CATEGORY | DIETARY  REQUIRMENTS | OTHER REQUIREMENTS | (DAYS) | ADMIT | DISCHARGE | SCANS | RESULT RECEIVED | RELEASED |  | WARD | ROOM | UNIT | MALE / FEMALE | CATEGORY | DIETARY  REQUIRMENTS | OTHER REQUIREMENTS | (DAYS) | ADMIT | DISCHARGE | SCANS | RESULT RECEIVED | RELEASED |  | WARD | ROOM | UNIT | MALE / FEMALE | CATEGORY | DIETARY  REQUIRMENTS | OTHER REQUIREMENTS | (DAYS) | ADMIT | DISCHARGE | SCANS | RESULT RECEIVED | RELEASED |  | WARD | ROOM | UNIT | MALE / FEMALE | CATEGORY | DIETARY  REQUIRMENTS | OTHER REQUIREMENTS | (DAYS) | ADMIT | DISCHARGE | SCANS | RESULT RECEIVED | RELEASED
0 | 24 | 1 | ICU |  | CATEGORY | [NAME] | Needs medication | 14 | 2020-03-25 00:00:00 | 2020-04-08 00:00:00 | Y | Y | YES |  | 25 | 1 | MED |  | CATEGORY | [NAME] | Needs medication | 14 | 2020-03-25 00:00:00 | 2020-04-08 00:00:00 | Y | Y | YES |  | 100 | 1 | MED |  | CATEGORY | [NAME] | medication | 14 | 2020-03-25 00:00:00 | 2020-04-08 00:00:00 | Y | Y | YES |  | 101 | 1 | MED |  | CATEGORY | [NAME] | Needs medication | 14 | 2020-03-25 00:00:00 | 2020-04-08 00:00:00 | Y | Y | YES
 |  | 1 |  |  | CAT3 |  |  | 14 |  |  | Y |  |  |  |  | 1 |  |  | CAT1 | - |  | 14 | 2022-04-23 00:00:00 |  |  |  |  |  |  | 1 |  |  | CAT1 | DIABETIC |  |  |  |  |  |  |  |  | 392 | 1 |  |  | CAT3 | - |  | 14 |  |  | Y | Y
 |  | 2 |  |  | CAT1 | - |  |  |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | CAT1 | - |  |  |  |  |  |  |  |  |  | 2 |  |  | CAT2 | -
 |  | 3 |  |  | CAT2 | CELIAC |  | 14 |  |  |  |  |  |  |  | 3 |  |  | CAT2 | VEGAN |  | 14 |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  | CAT1 | [NAME]
 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  | CAT1 | VEGETARIAN |  | 14 |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  |  | CAT0
 |  | 5 |  |  | CAT2 | fructose | Insulin | 10 | 2020-03-20 00:00:00 |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  | CAT1
 |  | 6 |  |  |  |  |  | 14 | 2020-04-15 00:00:00 |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | CAT1 | GLUTEN FREE |  |  |  |  |  |  |  |  |  | 6 |  |  | CAT2 | -
 |  | 7 |  |  | CAT3 | nut allegy |  |  | 2020-04-16 00:00:00 |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  | CAT1 | FRUCTOSE
 |  | 8 |  |  | CAT3 | - |  |  |  |  |  |  |  |  |  | 8 |  |  | CAT2 | - |  | 14 |  |  |  |  |  |  |  | 8 |  |  | CAT1 | NO EGG PRODUCT |  |  |  |  |  |  |  |  |  | 8
 |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  | CAT2 | - |  | 14 |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  | CAT1 | - |  |  |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 |  |  | CAT2 | NUT ALLERGY
 |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  |  | CAT1 | -
 |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  | CAT2 | PESCATARIAN |  | 14 | 2020-04-22 00:00:00 |  |  |  |  |  |  | 15
 |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  |  | CAT3 | - |  | 14 |  |  | Y | Y |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
 | WARD | ROOM | UNIT | MALE / FEMALE | CATEGORY | DIETARY  REQUIRMENTS | OTHER REQUIREMENTS | (DAYS) | ADMIT | DISCHARGE | SCANS | RESULT RECEIVED | RELEASED |  | WARD | ROOM | UNIT | MALE / FEMALE | CATEGORY | DIETARY  REQUIRMENTS | OTHER REQUIREMENTS | (DAYS) | ADMIT | DISCHARGE | SCANS | RESULT RECEIVED | RELEASED |  |  | 18 |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 | 26 | 1 | REHA |  | CATEGORY | [NAME] | Needs medication | 14 | 2020-03-25 00:00:00 | 2020-04-08 00:00:00 | Y | Y | YES |  | 32 | 1 | ED |  | CATEGORY | [NAME] | Needs medication | 14 | 2020-03-25 00:00:00 | 2020-04-08 00:00:00 | Y | Y | YES |  |  | 19 |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
 |  | 1 |  |  | CAT2 | - |  | 14 | 2020-04-22 00:00:00 |  | Y | N |  |  |  | 1 |  |  | CAT3 | - |  | 14 |  |  | Y | Y |  |  |  | 20 |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 |  |  | CAT2 | -
 |  | 2 |  |  | CAT3 | VEGAN |  | 21 | 2020-04-21 00:00:00 |  | Y | Y |  |  |  | 2 |  |  | CAT3 | FLUIDS ONLY |  | 14 | 2020-04-25 00:00:00 |  | Y | Y |  |  |  | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 |  |  | CAT2 | -
 |  | 3 |  |  | CAT1 | - |  |  |  |  |  |  |  |  |  | 3 |  |  | CAT2 | NIL BY MOUTH |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  |  | CAT2 | NO SEAFOOD
 |  | 4 |  |  | CAT2 | - |  |  |  |  |  |  |  |  |  | 4 |  |  | CAT2 | VEGAN |  |  |  |  |  |  |  |  |  | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 |  |  | CAT2 | -
 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | CAT3 | - |  |  |  |  |  |  |  |  |  | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 |  |  | CAT3 | NIL BY MOUTH |  |  |  |  |  |  |  |  |  | 28 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 |  |  | CAT2 | -
 |  | 12 |  |  | CAT3 | - |  | 14 | 2020-04-22 00:00:00 |  | Y | Y |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
 |  | 13 |  |  | CAT1 | GLUTEN FREE |  |  |  |  |  |  |  |  |  | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 |  |  |  |  |  |  |  |  |  |  |  |  |  | 11