Help

How can I automate/script/formula a duplication and editing process?

Topic Labels: Formulas if Scripting
Solved
Jump to Solution
1453 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Krys
4 - Data Explorer
4 - Data Explorer

Hi 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.

Example AirtableExample AirtableExample Google SheetsExample Google Sheets

 

 

Thank you,
Krys

1 Solution

Accepted Solutions
Alexey_Gusev
13 - Mars
13 - Mars

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

See Solution in Thread

1 Reply 1
Alexey_Gusev
13 - Mars
13 - Mars

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