Multiple Text to Rows

[jbqrn]

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!! :(

[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.

[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.

[binuacs]

@jbqrn one way of doing this

[jbqrn · Accepted solution]

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! :)