cancel
Showing results for 
Search instead for 
Did you mean: 

Split Text to Multiple Rows

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

[Output]
Row Column A Column B
1 Ball Red
2 Ball Blue
3 Ball  Yellow
4 Ball Green
Labels (1)
0 Kudos
1 Reply
Highlighted
Blue LED
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:
Image: https://us.v-cdn.net/6030933/uploads/editor/wi/cu4warr1568w.png

Input the correct separator ", " and accept Paxata's automatic insight on the number of columns to create:
Image: https://us.v-cdn.net/6030933/uploads/editor/ry/49eewuswfkt4.png

In Depivot, choose columns that stay put and repeat for every row created, then click REST to make the new columns create rows:
Image: https://us.v-cdn.net/6030933/uploads/editor/7a/4a84i8dd5fgj.png
0 Kudos