How do I sort data individually in a column when the data is given as a group?
The data I am looking at is movies and one of the columns is genres. However JMP has the genres that a particular movie is categorized under grouped as one data set "Fantasy|Horror|Romance|Thriller" rather than as individual movie genres "Fantasy", "Horror", "Romance", "Thriller". I want to separate the genre column so that I can analyze the genres individually. How would I clean the data so that ...