transformation of data in table using alteryx

[SahadhKuruniyan]

I have following data,

Name	Code 1	Code 2	Code 3
A	S4	1G
B	R4	0F	G4
C	2D	2F	L0
D	7U	E3	A2
E	J2	7T

How can I tranform to below

Name	Codes
A	S4
A	1G
B	R4
B	0F
B	G4
C	2D
C	2F
C	L0
D	7U
D	E3
D	A2
E	J2
E	7T

[gautiergodard · Accepted solution]

Hey @SahadhKuruniyan 

Here is one way to do it!

[binuacs]

@SahadhKuruniyan One way of doing this

[alexnajm]

Did you try the Transpose tool?