I am usually able to Google what I need to do in Excel and find an answer, but for this problem, I don't know what that which I'm trying to accomplish is called, so my searches have not been very successful. Please advise on what I should search or how I should go about solving this issue.
In a workbook that contains multiple tabs. Each tab has a course subject by grade level. For example Tab 1- 6th grade math Tab 2- 6th grade English Tab 3 6th grade science and so on.
On each tab there is a list of the students who qualify to take the Honors/Advanced section of that course.
I also have a summary tab that combines all of the six grade courses, and I have sorted it by student name any student who qualifies for more than one honors course (they appear on more than one tab) has all of their courses listed together.
I need to somehow shift this so that the student's name appears only once on the summary tab, with all of the course selections following the name on the same row.
I have attached an example.
Bookmarks