AnsweredAssumed Answered

How to Create csv file which includes multiple field entries on separate rows

Question asked by mad101dan on Jun 12, 2017
Latest reply on Jun 15, 2017 by fmpdude

Hi

 

I wonder if someone can help, here is what I need to achieve. Here is an example of my database.

 

NameCourse 1Course 2Course 3Couse 4
FredMathsEnglish
BobEnglish
SarahEnglishArtFrench

 

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.

 

Name,Course

Fred,Maths

Fred,English

Bob,English

Sarah,English

Sarah,Art

Sarah,French

Outcomes