I right now have a big issue which torch me for days.
I have a table like this
name course1 course2 course3
Chris 1 1 0
Patti 0 1 1
Alice 0 0 1
I want to have a result like:
Name CourseChosen
Chris course1
Chris course2
Patti course2
Patti course3
Alice course3
How could I do this? please help!
the number in the original table, 1 represents chosen and 0 represents non-chose.
Thanks for help!
Regards