I am having trouble trying to figure out how to only show on category in my dataset instead of all categories.
This is what my data looks like.
This is what it is supposed to look like.
I guess you want to split each category into one row.
If so, "Text To Columns" tool with "Split to rows" option may work.
Input
Configuration
Output
I hope this helps.
I would do a Formula and just hard code "International Movies" into the [Category]
Got this to work. Thank you
