Hi all--
I need help on how to transpose a large set of data which contains: year, term, student id, and sports. It gets complicated because there are some students that played multiple sports each term.
Here's what the raw data looks like:
<tbody>
YEAR_CODE
TERM_CODE
ID NUM
SPORTS...