I need some major help figuring out how to restructure my data file. I have a student data file with four variables:

1. Student ID (numeric - 1,000+ possible values)

2. Year (numeric - 5 possible values)

3. Name of Fall Math Course (string) - 30+ possible values

4. Name of Spring Math Course (string - 30+ possible values)

Students may have taken several different math courses over the years, or they may have repeated a math course, say if they failed or something. Therefore, Student IDs can be repeated, along with various Math Courses (like Algebra 1A)

Here are my research questions

1. How many Math classes has each student taken? (I could do an Aggregate command, but I'd prefer to exclude classes that students have repeated. Is there a way I can do that?)

2. How many advanced Math classes has each student taken? (I'd need to figure out a way to count 5 or so courses. And again, I'd like to exclude courses that were repeated.)

Any help will be much appreciated!!!