I wonder if someone can help, here is what I need to achieve. Here is an example of my database.
|Name||Course 1||Course 2||Course 3||Couse 4|
What I would like to do is to create a csv file which lists the person's name and each course they are doing on each line. So I want the export it to look like this.