I have a big list of students in Col A & their school form in Col B. I list each unique form as column headers from C onwards and underneath each header I want the list of students in that form.
My data sample looks like this:
<colgroup><col><col><col></colgroup><tbody>...