separating a single row into multiple

[Dannen_Shatto]

I have an excel sheet as an input. Each row represents a different book (about 1,000). One of the fields is genre and multiple genres are listed for each book in a single cell (ex. cell C4 includes "nonfiction,politics,history"). Is there a way I can split this into multiple rows based on genre? I'm wanting each row to only list one genre, even if I need to have multiple rows of the same book.

Please let me know of any useful tools for this.

Thank you!

[ggruccio]

Hi @Dannen_Shatto, 

I'd look at the Transpose tool. 

For instance the following workflow may produce the output you want.

Text Input:

Configuration of Transpose:

Output (in Browse):

[RolandSchubert · Accepted solution]

Hi @Dannen_Shatto ,

you can use a Text To Columns tool to split the column containing comma separated entries, and set it to "Split to rows". I've attached a sample workflow. Let me know, if it works for you.

Best,

Roland