I have a spreadsheet containing rows of data, the unique identifier is email address in Column A. Most cells (in column A) have only 1 email address, but other cells have multiple email addresses, separated by a comma.
In Google Sheets, I can use the SPLIT formula to take a cell with multiple email addresses, indicate that the comma is the delimitter, and Sheets will “split” the cell into multiple cells that contain 1 email address each. Example Formula: =SPLIT(A1,",")
I’d like to know: instead of needing to split out data using Google Sheets formulas, can I import the raw data into AirTable, and use an AirTable feature (data type, app/block/ automation, etc.) to split the data into multiple records using the comma as a delimitter.