Welcome to the Make community!
You’ll need to split the categories by comma-space so that it becomes an array.
Then, use an iterator on the array so that you can process each category at a time.
Create new category using the name.
Then, if category exists, there will be an error. Handle the error by searching for the category, and resuming with the existing category ID.
Then, aggregate the category IDs into an array using the Array Aggregator.
You can then insert the array of category IDs into the tag/category field.
Similarly, this works the same way for the Wordpress Tags, or any custom Taxonomy field.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!