Getting data to only show one filter

[etennison]

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.

[alexnajm]

I would do a Formula and just hard code "International Movies" into the [Category]

[Yoshiro_Fujimori · Accepted solution]

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

type	title	columns	category
Movie	aaa	xxx	ClassicMovies,Dramas,International Movies
Movie	bbb	yyy	Comedies,Dramas,International Movies

Configuration

Output

type	title	columns	category
Movie	aaa	xxx	ClassicMovies
Movie	aaa	xxx	Dramas
Movie	aaa	xxx	International Movies
Movie	bbb	yyy	Comedies
Movie	bbb	yyy	Dramas
Movie	bbb	yyy	International Movies

I hope this helps.

[etennison]

Got this to work. Thank you