How do I transpose multiple columns of data for one person into a single row?

There's no way I can describe this adequately in the question line.

I was given a spreadsheet. I was trying to get a spreadsheet of student names in one column, and down the row for each students, a list of classes in order of preference for the coming year.

The problem is, they gave me a list where the classes were arranged vertically.

Here is an example. I was given the list this way:

Student 1 | Class 1

Student 2 | Class 1

Student 2 | Class 2

Student 3 | Class 1

Student 3 | Class 2

Student 3 | Class 3

Student 3 | Class 4

Student 3 | Class 5

Student 4 | Class 1

Student 4 | Class 2

Student 4 | Class 3

.....

What I need is a list like this:

Student 1 | Class 1

Student 2 | Class 1 | Class 2

Student 3 | Class 1 | Class 2 | Class 3 | Class 4 | Class 5

Student 4 | Class 1 | Class 2 | Class 3

.....

Is there any way to convert the top to the bottom quickly? I could use transpose, but we're talking about thousands of individual students. I need something a bit more automated.