Code: Select all
Student ID Course Block
001 ENG A
001 FRE B
001 GER D
002 GEO A
002 GER D
002 FRE D
002 ENG E
etc
Code: Select all
Student ID A B C D E F G H
001 ENG FRE GER
002 GEO GER ENG
002 FRE
or maybe
Student ID A B C D E F G H
001 ENG FRE GER
002 GEO GER/FRE ENG
Blocks are A to H, but not every block will be used for each student, and some blocks are used more than once.
The data has been extracted using SQL, so if there's a better way of formatting the raw data that way, I'm open to suggestions!