Multiple Text to Rows

Hi everyone,

I am trying to split some text inside some cells into rows, i know how text to columns (rows) works but I would like to do it for all columns that have a delimiter (two data)

Example:

I have 76 columns (only one row because it is a sample, it is supposed to be 1000+ rows) and I want it to split all cells that has the data into two rows (there are no more than 2 data).

I am trying with transpose and text to columns but I don't achieve the desired solution...

Help!!

Datasets

Tips and Tricks

Parse

Help

Accepted answers

jbqrn

Hiiii everyone, thanks for the help!!

I finally arrived to this solution:

DATA SET

Corss Tab First and Last and Union by field.

Final dataset:

As I only have two possible values and the dataset follows a certain structure, this solution fits what I need.

Thanks for all the help!

All comments

Emmanuel_G

@jbqrn

Find in attachement the way of doing that.

It works with as many as fields that you want.

Let me know if there is any issue and please, do not hesitate to mark this answer as solution if it helped.

Multiple Text to Rows.yxmd

DataNath

@jbqrn here's a way of doing this which involves Transposing the data before splitting. This ought to be dynamic and also handles the usual issue of the Cross-Tab tool ruining the sort and naming of your headers. Had to use a quick mock up of data as you didn't provide any but should still be applicable. Let us know if you run into any issues.

Split cells into 2 rows if delimiter.yxmd

binu_acs

@jbqrn one way of doing this

Multi_Text_0928.yxmd

jbqrn

Hiiii everyone, thanks for the help!!

I finally arrived to this solution:

DATA SET

Corss Tab First and Last and Union by field.

Final dataset:

As I only have two possible values and the dataset follows a certain structure, this solution fits what I need.

Thanks for all the help!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703