Showing results for 
Search instead for 
Did you mean: 

Split Text to Multiple Rows

Split Text to Multiple Rows

Hi, how do I split a text into multiple rows.
For eg: [Input]
Row Column A Column B
1 Ball Red, Blue, Yellow, Green

Row Column A Column B
1 Ball Red
2 Ball Blue
3 Ball  Yellow
4 Ball Green
Labels (1)
1 Reply

In order to accomplish your goal, you will need to employ two transformations.

First, split your Column B into separate columns, as many as the row that has the most values. Then, use the Shape : Depivot capability to generate rows for those values.

Select the menu option:

Input the correct separator ", " and accept Paxata's automatic insight on the number of columns to create:

In Depivot, choose columns that stay put and repeat for every row created, then click REST to make the new columns create rows: