Solved! Go to Solution.
If I understand this correctly, you want to view the data associated with each category in a separate table.
Create a new table within the same base, create a new linked field between the two tables, in original table copy data from Categories field to linked field for the new table. Airtable automatically seperates multi-select items using comma. When you copy paste fields in a Linked Type field it will populate as individual records.
Happy to help!
Thanks for your idea, Harleen. But unfortunately, I don't think my question was clear though.
I don't want to copy the individual record data from the Categories Field that is in one table to another.
I want to export the List that is created inside the Multiple Select Field for the Categories (ie list that user pulls down to select a Category - such as Personal, Business, Other). Then have each Category be a record in another Table that would be in its own Table entitled "Categories".
Hopefully that is a little clearer. Thank you again for your help!