Export - Single Record has multiple fields

[lb.fam]

Hello,

I am exporting my data to Csv format, and my application contains a roster.

If I select Number of Files Created: One File and Output of Multiple Record Occurrences: All in One Record (see attached Export1) a single Csv file is created, but for each field it repeats twenty times- A1_01, A1_02, A1_03......................A1_20.

The first field contains the value captured, the others are blank.

If I select Number of Files Created: Multiple Files and Output of Multiple Record Occurrences: As Separate Records (see attached Export2) then the fields aren't repeated, but I now have three separate records, which I then have to join manually.

Any idea how to generate a single file without repeating fields?

Export1.png

Export2.png