Hi all!
I am trying to repeat an index/attributes for each new row value in a table. For example, whether for {site:text} or {clipboard}, I would like to capture and map column attributes to individual row values recursively.
I've tried several formulas but I can't seem to get it to work. See a choppy example below.
{cell1=split({clipboard}, "\t")[1]}
{cell2=split({clipboard}, "\t")[2]}
{cell3=split({clipboard}, "\t")[3]}
{repeat: for rows in split(NewRow, "\n")}
Name: {=cell1}
City: {=cell2}
Address: {=cell3}
{endrepeat}
Any suggestions or ideas to accomplish this? If it doesn't make sense, let me know. Thank you!!!