I have a CSV file that imports like this:
Field1_Entry1,Field2_Entry1,...FieldN_Entry1,Field1_Entry2,Field2_Entry2...
I intend to have a new row after Field N so I get a table with N columns:
Field1_Entry1 | Field2_Entry1 | ...FieldN_Entry1
Field1_Entry2 | Field2_Entry2 | ...FieldN_Entry2
etc
Fwiw I have been able to insert a blank column after each FieldN using a delimiter but I haven't figured out how to jump to a new row.
Any ideas?
Thanks.