I am trying to make a specific CSV export file from an existing Filemaker database where the contents of three different fields need to export one after the other with the same record ID (a unique value). Thus it would need to export three lines per record.
It seems as though a portal could be used with a repeating field containing the three different field values but I do not know how to get that data into the repeating field. Note that in the export file, it is not required for the ID numbers to repeat as shown in the screenshot as only the first line for each new ID would be required (though the could be repeated as shown).
I have attached two simple spreadsheet screenshots to illustrate what the records in the database contain and how that needs to get exported.
Any thoughts or assistance would be greatly appreciated!