Split content of a cell into lines

[Thomas_Feray]

Dear Alteryx community,

Here is my problem today, I've tried several ways, but did not get the expected result:

1. I have several columns which include several rows of data
2. Each row has multiple lines of data in it
3. I would like to be able to separate each line of data from each row
4. Each line of data should be, eventually, a row. 

I include an excel file to be more explicit about my request. The first tab show how the data that I have is extracted and the tab "Expected results"... well... shows the objective I would like to achieve! 😁

Any idea as to how to proceed?

TF

[DavidSkaife · Accepted solution]

Hi @Thomas_Feray 

Here is a way of doing it:

Split each column into rows using the Text to Columns tool with a delimiter of \n

Deselect unwanted fields from each stream

Join back together on Record Position using the Join Multiple Tool

Tidy up the columns using a formula tool and the Substring function

[ConnorK]

Hi @Thomas_Feray ,

Please take a look at the attached workflow. The best way I find to do this is by Transposing all the columns into one row, then using the Text-to-Columns tool to split into rows. From there you can Cross-Tab the data back into its original layout.

Best,

[Thomas_Feray]

Hi @DavidSkaife,

Thank you very much for the solution, it works very well!

Regards,

Thomas

[Thomas_Feray]

Hi @ConnorK, 

This solution works as well! Thank you for the time spent to solve my problem!

Regards,

Thomas