I have a sheet with student details across 7 columns and then in the 8th are their classes. The classes populate down for however many rows there are classes (different for groups of students). What I need to do is have the student details data repeated for every class they take up until the next student (the next row that has data in it).
What is a quick way to do this?! There must be one but I cannot find what I am looking for anywhere!
Thanks
Adam
What is a quick way to do this?! There must be one but I cannot find what I am looking for anywhere!
Thanks
Adam