Paid work! Can anyone offer some consultancy / A Solution?
I am importing data (via a Zapier Action) from an external data feed using Knack. One of the field types I am importing is from a Data Matrix with Rows and Columns. It is being imported as a single text area field.
In knack terms each row is a field, and the selected column is the answer.
I need to do the following: the data looks like this:
"row 1 = Column 1
Row 2 = Column 2
Row 3 = Column 3
Row 4 = Column 4"
What I needs in the same data table is:
First Answer: Row 1 = Column 1
Second Answer field: Row 2 = Column 2
Third answer: Row 3 = Column 3
Fourth answer: Row 4 = Column 4
Can anyone help please?