How to combine two fields in pair but separate lines?
My airtable has two fields, for example, 1st field name is "Test" and 2nd field name is "Solution". Records from both fields are come from Lookup of other fields so multiple records appear in "Test" and "Solution". i.e. one record of 'Test' contains 'Test item 1, 2 & 3'. One record of 'Solution' contain 'Solution item 1, 2, & 3'.I use below formula to present Test item 1, Test item 2, Test item 3 in separate lines under one record of "Test" fields. Solution item 1, Solution item 2, Solution item 3 in separate lines under one record of "Solution" field. SUBSTITUTE(
ARRAYJOIN({Your Lookup Field}),
",","\n"
)However, I would like to present the information in pair but separate line in NEW FIELD? e.g. 1st line - Test item 12nd line - Solution item 13rd line - Test item 24th line - Solution item 25th line - Test item 36th line - Solution item 3Would anyone propose how to do it? T
