^^ example… Each blog has multiple categories but when I import it they stay together and make one big category. Any idea on how I can separate these categories and organize them into their own categories?
1 Like
Did you create a “category” collection and set a multi-reference field in your “blog” collection? If so, try using a “;” as the separator instead of “|”.
Sorry if I am a little dumb on the subject. Is there a way to replace the | with ;?
You should be able to do a simple Find and Replace across the column:
Sheets:
https://support.google.com/docs/answer/62754
Excel: