If it puts the data in cells going across the sheet, then what happens
if you have more than 256 students? If you don't have this many, then
you can transpose the data so that it appears in column A only -
highlight the cells from A1 to however many you have on row 1, click
<copy then move the cursor to A3 (for example) and Edit | Paste
Special | Values (check) and check Transpose, then OK and <Esc. You
can then delete row 1.

You could then think about separating the data out into separate
columns - Data | Text-to-Columns might work if you have some character
to use as delimiter, or you might have to develop some formulae
including LEFT, MID, RIGHT etc to split the data up - it would help if
you posted 2 or 3 examples of the data you have at the moment.

Hope this helps.

Pete