I just imported a spreadsheet that currently has a column that would be a “multiple select” in airtable, each entry separated by a semicolon.
For example, here’s how a few cells in the column might look:
Alabama; Michigan; Massachusetts
New Hampshire; Alabama
Massachusetts; New Hampshire; Maine
I have already created an empty table in the base named “States” and I want to convert that column type to a “Link to another record” in such a way that creates records in the way that one might expect: one entry per State.
However, using the GUI interface I have only managed to get Airtable to do the dumb thing of converting each cell as one thing. Is there any way to do better?