Here is the situation: I have a csv file. The file has:
row 1 jsmith, math
row 2 jsmith, english
row 3 jsmith, history
row 4 jsmith, science
row 5 jdoe, math
row 6 jdoe, science
row 7 jdoe, english
row 8 jdoe, spanish
etc.
What I want is to end up with is this:
row 1 jsmith, math, english, history, science
row 2 jdoe, math, science, english, spanish

Any ideas? Access, Excel or Mysql? Help please.