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

Question for the community.xlsx

davidskaife

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

Split Data.yxmd