W
wasi64
I am working with an Excel worksheet. The worksheet contain students
schedule for a high school. Most of the students are having two rows.
The first row contains student and their class name. The second rows
containing the room number bellow the class name. Some students are
occupying 4 rows. First two rows are same for every one but other two
rows containing additional class at the same period. Example: at the
4th period some students have 'GYM' for 3 days and 'LAB' for 2 days.
This ‘LAB’ is occupying extra 2 rows.
Now I like cut this 'LAB' class and pest that to the same rows that
contains the name and room number of the student.
How can I do that? I have +/- 4000 students.
schedule for a high school. Most of the students are having two rows.
The first row contains student and their class name. The second rows
containing the room number bellow the class name. Some students are
occupying 4 rows. First two rows are same for every one but other two
rows containing additional class at the same period. Example: at the
4th period some students have 'GYM' for 3 days and 'LAB' for 2 days.
This ‘LAB’ is occupying extra 2 rows.
Now I like cut this 'LAB' class and pest that to the same rows that
contains the name and room number of the student.
How can I do that? I have +/- 4000 students.