Another day another plea for help :)
I have a spreadsheet with 255,398 rows. Each student has anything between 5 to a 1000 rows, however, not each row has the student's details. So the table (in a very simplified form) looks something like this
<tbody>
Surname
Forename
UPN
Achievement...