Formula in N should create as many rows with a student's ID name as there are courses selected in column(s) B through M, and the formula in O is supposed to transpose the courses selected by each student. It only works for first 5 students and first 5 courses selected. Can anyone fix it so that I can use it with 1000 students and all the courses shown for each student?