Spreadsheet: 77085d1277511034-extract-room-number-and-student-id-and-put-them-in-other-cells-studenthousing
Sheet: ROSTER

STUDENT | BLDG | ROOM
Student1 | OFF CAMPUS | OFF CAMPUS
Student2 | ??? | ???
Student3 | N/A | N/A
Student4 | 3910 | 131
Student5 | 3910 | 107A
Student6 | 3910 | 108B
Student7 | 3910 | 112B
Student8 | 3910 | 116A
Student9 | 3910 | 120B
Student10 | 3910 | 127A
Student11 | 3910 | 127B
Student12 | 3910 | 129A
Student13 | 3910 | 137B
Student14 | 3717 | 115
Student15 | 3717 | 124
Student16 | 3717 | 207
Student17 | 3717 | 314
Student18 | 3717 | 314
Student19 | 3717 | 101A
Student20 | 3717 | 119B
Student21 | 3717 | 121A
Student22 | 3717 | 121B
Student23 | 3717 | 122B
Student24 | 3717 | 218A
Student25 | 3717 | 218B
Student26 | 3717 | 223A
Student27 | 3716 | 215
Student28 | 3716 | 300
Student29 | 3716 | 305
Student30 | 3716 | 307
Student31 | 3716 | 116A
Student32 | 3716 | 201B
Student33 | 3716 | 205B
Student34 | 3716 | 212A
Student35 | 3716 | 307A
Student36 | 3716 | 308B
Student37 | 3716 | 317B
Student38 | 3715 | 105
Student39 | 3715 | 109
Student40 | 3715 | 318
Student41 | 3715 | 206A
Student42 | 3715 | 207B
Student43 | 3715 | 210A
Student44 | 3715 | 212A
Student45 | 3710 | 13D
Student46 | 3710 | 14C
Student47 | 3710 | 24B
Student48 | 3710 | 32A
Student49 | 3709 | 11B
Student50 | 3709 | 11B
Student51 | 3709 | 11B
Student52 | 3709 | 24B
Student53 | 3709 | 33B
Student54 | 3708 | 12A
Student55 | 3708 | 24B
Student56 | 3708 | 31B
Student57 | 3708 | 33D
Student58 | 3707 | 14C
Student59 | 3707 | 21B
Student60 | 3707 | 24B
Student61 | 3515 | 102
Student62 | 1090 | 101A
Student63 | 1090 | 105A
Student64 | 1090 | 201B
Student65 | 1090 | 203B
Student66 | 1090 | 204A
Student67 | 1090 | 204B
Student68 | 1090 | 205A
Student69 | 1090 | 206A
Student70 | 1090 | 206B
Student71 | 1090 | 208A
Student72 | 1090 | 209A
Student73 | 1090 | 210A
Student74 | 1090 | 210B
Student75 | 1090 | 211A
Student76 | 1090 | 215B
Student77 | 1090 | 301A
Student78 | 1090 | 302A
Student79 | 1090 | 302B
Student80 | 1090 | 305A
Student81 | 1090 | 306A
Student82 | 1090 | 306A
Student83 | 1090 | 306B
Student84 | 1090 | 307A
Student85 | 1090 | 309A
Student86 | 1090 | 311A
Student87 | 1090 | 311B
Student88 | 1090 | 312B
Student89 | 1090 | 313A
Student90 | 1090 | 314A
Student91 | 1090 | 314B
Student92 | 1090 | 315A
Student93 | 1090 | 315B
Student94 | 1084 | 102
Student95 | 1084 | 103
Student96 | 1084 | 104
Student97 | 1084 | 106A
Student98 | 1084 | 108A
Student99 | 1084 | 202A
Student100 | 1084 | 205B
Student101 | 1084 | 211B
Student102 | 1084 | 215B
Student103 | 1084 | 303A
Student104 | 1084 | 315B
Student105 | 1084 | 404B
Student106 | 1084 | 407B
Student107 | 1084 | 415A
Student108 | 1084 | 416A
Student109 | 1084 | 416B
Student110 | 1084 | 418B
Student111 | 1082 | 416
Student112 | 1082 | 104A
Student113 | 1082 | 104B
Student114 | 1082 | 105B
Student115 | 1082 | 106B
Student116 | 1082 | 109B
Student117 | 1082 | 112A
Student118 | 1082 | 112B
Student119 | 1082 | 210B
Student120 | 1082 | 301A
Student121 | 1082 | 305B
Student122 | 1082 | 306A
Student123 | 1082 | 306B
Student124 | 1082 | 306B
Student125 | 1082 | 309A
Student126 | 1082 | 309B
Student127 | 1082 | 309B
Student128 | 1082 | 313B
Student129 | 1082 | 317B
Student130 | 1082 | 319B
Student131 | 1082 | 401A
Student132 | 1082 | 411B
Student133 | 1082 | 415B