Text to column - automation help needed

[tomekgagola]

Hi,

I have the datasets that is something like below:

Value	ID
1	A,B,C
2	AA,BB,CC
3	A1,A2,A3
4	A2,B2,C2,C4

Here is the desired outcome:

Value	ID
1	A
1	B
1	C
2	AA
2	BB
2	CC
3	A1
3	A2
3	A3
4	A2
4	B2
4	C2
4	C4

I am able to do it in designer using workflow, however the method I use is very static and needs multiple selects. I wondered if there is a way to do it in more automatic way especially that my dataset might contain +25 ID initially inside the same cell.

[atcodedog05 · Accepted solution]

Hi @tomekgagola 

Configure Text to Column like below

Hope this helps : )

[tomekgagola]

That was quick. Appreciate it.

[atcodedog05]

Happy to help : ) @tomekgagola 

Cheers and have a nice day!