Splitting Concatenated Data into specific amount of rows

[scollier1993]

Hello!

I have data that basically looks like this:

Code1	AB,XZ,CD	33,66,77
Code2	DF,ER	22,44
Code3	RO	11
Code4	FO,PL,LU,XY	79,67,19,79

I would like it to look like this though:

Code1	AB	33
Code1	XZ	66
Code1	CD	77
Code2	DF	22
Code2	ER	44
Code3	RO	11
Code4	FO	79
Code4	PL	67
Code4	LU	19
Code4	XY	79

Any thoughts how this could be achieved?

Thank you!

[ShankerV]

Hi @scollier1993 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @scollier1993 

Step 1: Input

Step 2;

Step 3: 

Step 4:

Many thanks

Shanker V

[binuacs]

@scollier1993 Another method of doing this