VBA to build schedule

[johnsmith5050]

Hello

I am looking to use vba to tidy up an unstructured list under relevant column headings.


Currently the data has one unique row for each class/student combination. Instead I am hoping to have one row per unique student to show all classes they may have assigned to them in a single row.

Class	Morning/Afternoon	Name
Math	Afternoon	Scott
English	Morning	Scott

Example of updated grouping / structure:

Name | Morning 1 | Morning 2 | Morning 3 | Morning 4| Morning 5 | Morning 6 | Afternoon 1 | Afternoon 2 | Afternoon 3 | Afternoon 4 | Afternoon 5 | Afternoon 6
Scott | French | English | Chemistry | Biology | <Blank> | <Blank> | PE | Software | Math | Physics | <Blank | Blank>


The number of classes a student can have can vary so some may have more entries in the list than others. The maximum currently for morning or afternoon is 6 subjects for each session. Cell can remain blank if there is less subjects assigned than the maximum.

Thanks in advance for any help, please let me know if more information may be required.

EDIT:
Ideally it can review the output on 'tab 1' and create the new structured output on 'tab 2' to avoid modifying original data.