0
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.
1I am assuming that the "..." is not inside the file? but it is seperated with a comma? – veritaS – 2018-01-06T08:58:01.953
yes indeed, my bad, all values are separated in commas, I just new a new row after every N columns – Argonyth – 2018-01-06T09:05:14.720