Parsing the data

[Idyllic_Data_Geek]

I will like to split a row into multiple rows, if a column has values separated by a comma

For example ,

lob	Number
A	908642,03950345
B	0383589,0395122,1243584

The above should be prepared as below,

lob	Number
A	908642
A	03950345
B	0383589
B	0395122
B	1243584

[ChrisTX · Accepted solution]

Use the Text to Columns tool, and choose the radio button for Split to rows.

Chris

[Jay-RDC · Accepted solution]

To be specific.