Spreadsheet: 163490d1340323631-combine-multiple-rows-into-a-single-row-with-concatenation-studenttimetable
Sheet: Result for 3 students

Student Code | First Name | Last Name | House | Home Group | Year Level | Subject | Teacher | Room | Day | Period | Monday HR | Monday Period 1 | Monday Period 2 | Monday Period 3 | Monday Period 4 | Monday Period 5 | Monday Period 6 | Tuesday HR | Tuesday Period 1 | Tuesday Period 2 | Tuesday Period 3 | Tuesday Period 4 | Tuesday Period 5 | Tuesday Period 6 | Wednesday HR | Wednesday Period 1 | Wednesday Period 2 | Wednesday Period 3 | Wednesday Period 4 | Wednesday Period 5 | Wednesday Period 6 | Thursday HR | Thursday Period 1 | Thursday Period 2 | Thursday Period 3 | Thursday Period 4 | Thursday Period 5 | Thursday Period 6 | Friday HR | Friday Period 1 | Friday Period 2 | Friday Period 3 | Friday Period 4 | Friday Period 5 | Friday Period 6
ADAMD01 | [NAME] | ADAMS | SWAN | 12A | 12 | Homeroom Yr12 | [NAME] | S11 | Monday | HR | Homeroom Yr12 [NAME] | Physics Yr12 [NAME] LAB2 | Physics Yr12 [NAME] LAB2 | Private Study Yr12 [NAME] S26 | Materials Technology Yr12 Wayne THOMSON AT8 | Religious Education Yr12 [NAME] | English Yr12 [NAME] S21 | Homeroom Yr12 [NAME] | Religious Education Yr12 [NAME] | Religious Education Yr12 [NAME] | Maths: General Yr12 Monique GIBSON S12 | Materials Technology Yr12 Wayne THOMSON AT8 | English Yr12 [NAME] S21 | Physics Yr12 [NAME] LAB2 | Homeroom Yr12 [NAME] | Private Study Yr12 Danielle ATKINSON S26 | Private Study Yr12 Heather BELL S26 | Materials Technology Yr12 Wayne THOMSON AT8 | Materials Technology Yr12 Wayne THOMSON AT8 | English Yr12 [NAME] S21 | Maths: General Yr12 Monique GIBSON S12 | Homeroom Yr12 [NAME] | Materials Technology Yr12 Wayne THOMSON AT8 | Religious Education Yr12 [NAME] | Maths: General Yr12 Monique GIBSON S12 | Maths: General Yr12 Monique GIBSON S12 | Physics Yr12 [NAME] LAB2 | Private Study Yr12 [NAME] S26 | Homeroom Yr12 [NAME] | English Yr12 [NAME] S21 | English Yr12 [NAME] S21 | Maths: General Yr12 Monique GIBSON S12 | Religious Education Yr12 [NAME] | Private Study Yr12 Joanne BOYLE S26 | Physics Yr12 [NAME] LAB2
ALTMR01 | [NAME] | ALTMAN | SWAN | 12D | 12 | Homeroom Yr12 | Eva WHITE | S14 | Monday | HR | Homeroom Yr12 Eva WHITE S14 | English Yr12 [NAME] S21 | English Yr12 [NAME] S21 | Physical Education Yr12 [NAME] | Maths: General Yr12 [NAME] S13 | Religious Education Yr12 [NAME] | Private Study Yr12 Trish NANCARROW S26 | Homeroom Yr12 Eva WHITE S14 | Religious Education Yr12 [NAME] | Religious Education Yr12 [NAME] | Environmental Studies Yr12 [NAME] LAB2 | Maths: General Yr12 [NAME] S13 | Private Study Yr12 [NAME] S26 | English Yr12 [NAME] S21 | Homeroom Yr12 Eva WHITE S14 | Physical Education Yr12 [NAME] | Physical Education Yr12 [NAME] | Maths: General Yr12 [NAME] S13 | Maths: General Yr12 [NAME] S13 | Private Study Yr12 [NAME]S26 | Environmental Studies Yr12 [NAME] LAB2 | Homeroom Yr12 Eva WHITE S14 | Maths: General Yr12 [NAME] S13 | Religious Education Yr12 [NAME] | Environmental Studies Yr12 [NAME] LAB2 | Environmental Studies Yr12 [NAME] LAB2 | English Yr12 [NAME] S21 | Physical Education Yr12 [NAME] | Homeroom Yr12 Eva WHITE S14 | Private Study Yr12 [NAME]S26 | Private Study Yr12 [NAME] | Environmental Studies Yr12 [NAME] LAB2 | Religious Education Yr12 [NAME] | Physical Education Yr12 [NAME] | English Yr12 [NAME] S21
BACHM01 | [NAME] | BACHELARD | SWAN | 12B | 12 | Homeroom Yr12 | [NAME] | S12 | Monday | HR | Homeroom Yr12 [NAME] S12 | Environmental Studies Yr12 [NAME] LAB1 | Environmental Studies Yr12 [NAME] LAB1 | Private Study Yr12 [NAME] S26 | Outdoor Education Yr12 [NAME] | Religious Education Yr12 [NAME] | English Yr12 [NAME] S21 | Homeroom Yr12 [NAME] S12 | Religious Education Yr12 [NAME] | Religious Education Yr12 [NAME] | Maths: General Yr12 Monique GIBSON S12 | Outdoor Education Yr12 [NAME] | English Yr12 [NAME] S21 | Environmental Studies Yr12 [NAME] LAB1 | Homeroom Yr12 [NAME] S12 | Private Study Yr12 Danielle ATKINSON S26 | Private Study Yr12 Heather BELL S26 | Outdoor Education Yr12 [NAME] | Outdoor Education Yr12 [NAME] | English Yr12 [NAME] S21 | Maths: General Yr12 Monique GIBSON S12 | Homeroom Yr12 [NAME] S12 | Outdoor Education Yr12 [NAME] | Religious Education Yr12 [NAME] | Maths: General Yr12 Monique GIBSON S12 | Maths: General Yr12 Monique GIBSON S12 | Environmental Studies Yr12 [NAME] LAB1 | Private Study Yr12 [NAME] S26 | Homeroom Yr12 [NAME] S12 | English Yr12 [NAME] S21 | English Yr12 [NAME] S21 | Maths: General Yr12 Monique GIBSON S12 | Religious Education Yr12 [NAME] | Private Study Yr12 Joanne BOYLE S26 | Environmental Studies Yr12 [NAME] LAB1
 | Instructions
 | How I got the data to look like this…
 | 1.  Column headers in J and K are concatenated to Column L and beyond equal to the number of rows for an individual student
 | 2.  Use the formula: '=G2&CHAR(10)&H2&CHAR(10)&I2' and fill down all the rows for an individual student, then copy/paste as values, then copy/paste transposed to the students first row
 | 3.  Delete the now irrelevent additional rows for the student at step 2, repeat step 2 for the next student and so on…
 | Great if you could write a macro for this.
 | Thanks in advance
 | [NAME]