Separating data in a single cell to multiple rows

Hello,

I'm hoping to get help / ideas here. I have a table with some of the records in the table having multiple records within itself. The data is separated by line breaks.

At first, I thought it would be easy to do in Alteryx but I got stuck for hours now.

I attached the sample input and the desired output.

Sample Data for Alteryx Community.xlsx

Workflow

Preparation

Accepted answers

FinnCharlton

Hi @bjprado16_spgi , here's how to do this. The key is to transpose your data so all the target cells are in one column, and then use the Text-To-Columns tool using \n as the delimiter. \n is the new-line character:

Screenshot 2023-07-18 133535.png

Hope this helps!

Split Data to Rows.yxmd

All comments

FinnCharlton

Screenshot 2023-07-18 133535.png

Hope this helps!

Split Data to Rows.yxmd

jdminton

You can do this with the text to columns tool. Use the “Split to rows” option and set the delimiter to \n which indicates a new line.

binu_acs

@bjprado16_spgi One way of doing this

Screenshot 2023-07-18 134028.png

Transpose_180723.yxmd

bjprado16_spgi

Thanks everyone for the help! I didn't think of transforming the data that way. I tried the text to columns tool before but my problem was that it repeats the data from the other columns which is not I wanted.

Thanks again for the help!

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

RithiS 280