1 2 Previous Next 21 Replies Latest reply on Jun 15, 2017 12:36 PM by fmpdude

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

    mad101dan

      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

        1 2 Previous Next