I have an email that has “data info” and it goes through MailParser to Airtable through Zapier. All works great but, Now the data of this email is all in 1 row (multiple columns) I was wondering if there is a formula that can take “some of the columns i identify” and create a new row.
If you take a look above, sample.
I want to be able to create a new row of from current row 370.
TRANSFER TEST 2 with the Audition Date 1 into a new row
TRANSFER TEST 2 with the Audition Date 2 into a new row
I hope this makes sense.