Hello - I am working on a school schedule. I have a list of students and each of their course they have selected. Each course is in a separate row however (creating multiple rows for each student). I would like to have a single row for each student, but each course in the correct column (English, Math, Science, etc.).
I am stuck between =if and =vlookup and a VBA. I am relatively new to excel (especially at this level). Any and all help is greatly appreciated!
I am stuck between =if and =vlookup and a VBA. I am relatively new to excel (especially at this level). Any and all help is greatly appreciated!