Click on the column header for the column in question(genres). Then go to the column pull down menu and select
Cols=>Utilities=>Text to Columns
Fill out the simple dialog box that pops up to specify your "|"
![txnelson_1-1648353801488.png txnelson_1-1648353801488.png](https://community.jmp.com/t5/image/serverpage/image-id/41186i8ACA6CD83068E271/image-size/medium?v=v2&px=400)
and click OK, and the different fields from the multiple field column will be separated into new columns.
![txnelson_2-1648356183265.png txnelson_2-1648356183265.png](https://community.jmp.com/t5/image/serverpage/image-id/41187i5C465612237A7E93/image-dimensions/690x238?v=v2)
Note: This is a data table I just threw together. The genres are just random values
Now just go to
Tables=>Stack
and stack all of the new genres columns
This will give you a table that actually will give you a nice way to select Genres.
![txnelson_3-1648356385425.png txnelson_3-1648356385425.png](https://community.jmp.com/t5/image/serverpage/image-id/41188iEBACF3F5AFAE0170/image-dimensions/779x409?v=v2)
You can also go another step, and split the data
Tables=>Split
Where you Split By the Genres column, Group by the Title column, and also specify the Genres column as the Split column
It will give you a data table like the one below
![txnelson_4-1648356597287.png txnelson_4-1648356597287.png](https://community.jmp.com/t5/image/serverpage/image-id/41189iEDFACA35DDB2E22B/image-dimensions/868x420?v=v2)
If this doesn't meet your requirements, please specify what you want the data table to look like, and I am sure the Community can come up with an answer on how to transform your data.
Jim