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 |
Solved! Go to Solution.
Use the Text to Columns tool, and choose the radio button for Split to rows.
Chris
To be specific.