Formula to Join Arrays in Order?


Apologies as I’m not quite sure how to word this…

My end goal is to create an HTML table that I can send in an email using Zapier. I have several Rollup fields containing the values I want to insert into the table.

I guess the most straightforward way I can put this is… is it possible to create a formula - in either Airtable or Zapier - to aggregate several different arrays together in order?

[Array1 Item1], [Array2 Item1], [Array3 Item1], [Array1 Item2], [Array2 Item2], [Array3 Item2]

Thank you!


Managed to avoid having to solve this problem… here is the workaround I used if anyone is interested! Zapier Emails: Create a Table From Linked Records