+1Hi Airtable community,
Attached photos show problem and desired solution separated by the empty row. One example in Airtable. Second example in Google Sheets. This is a small sample of a much larger dataset (hence the query).
If Column-B contains 2> (2 or more) names/items then I want that row to duplicate with separate unique Column-B names/items.
Your formula/script/automation and how to implement would be greatly appreciated and helpful.
Thank you,
Krys
Best answer by Alexey_Gusev
Hi,
Duplicate Column B and change the copy field type to "Link to .. (new table)". In this new table, add necessary fields (A,C) via lookups. copy-paste to desired location
It may not work ok if you have non-unique values in B
+23Hi,
Duplicate Column B and change the copy field type to "Link to .. (new table)". In this new table, add necessary fields (A,C) via lookups. copy-paste to desired location
It may not work ok if you have non-unique values in B
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
