I have below row data shown as below in sample and I want a formula to populate expected results shown
ABCDEFGHIJK1Row DataExpected Result2NameCourse Name 1Course Name 2Course Name 3Course Name 4Course Name 5NameCourses3Name 1Course1Course2Name 1Course14Name 2Course1Name 1Course25Name...