Alteryx Transpose Data and Split Words

[Andrew_Seaman]

I have some text I need to transpose and separate out the words with.  Note some of the text can appear on multiple lines in the cell like.

"Sentence one.

Sentence two."

Here is my source data:

Here is my output:

[Maskell_Rascal · Accepted solution]

Hi @Andrew_Seaman 

So it looks like you don't need a transpose, but a Text to Columns set to Split to rows. To handle both a new line and spaces, we can configure the tool to handle both delimiters. 

When ran, the output appears to give the desired results. I even threw in a couple examples where a few cells had new lines embedded. 

Attached is a sample workflow for you to try. 

If this solves the problem please mark answer as correct, if not let me know!

Cheers!

Phil

[MichaelSu]

Hi @Andrew_Seaman ,

See attached. You can use the text to columns tool and split by rows. \s is the delimiter for a space.

Thanks,

Mike

[MichaelSu]

Didn't realize @Maskell_Rascal  has the solution as well. Both work!

Thanks,

Mike

[apathetichell]

@MichaelSuand @Maskell_Rascal are 100% correct but there is a contingent of us who want REGEX answers -and only REGEX answers, for them, may I suggest adding a record id and a regex tool set to tokenize and split to rows. Field should be [text] and the formula should say:

([a-z]+)

(with case insensitive checked)...

Once more the chaotic\sspirits of REGEX have been appeased.