Split into multiple rows

[Venamma]

Hi Team,

I have a table mentioned below and am looking for the result as shown in the second table.

Can someone please help me with the solution?

Input:

Key	Code	Text
K01	1~2~3~4~5	FCW~CIW~VDW~AWS~SFT
K02	7~8~9	WFT~ADB~SPRL

Result:

Key	Code	Text
K01	1	FCW
K01	2	CIW
K01	3	VDW
K01	4	AWS
K01	5	SFT
K02	7	SFT
K02	8	ADB
K02	9	SPRL

Regards,

Venamma

[binuacs]

@Venamma One way of doing this with the help of batch macro

[Qiu · Accepted solution]

@Venamma 
Another approach without macro.

For Code 7, its text value shall be "WFT", right?

[CoG · Accepted solution]

Another simple solution! It amazes me how many different ways these problems can be tackled with Alteryx: