How to transpose excel data?

[deadeye123]

the way i have it displayed is like below:

Customer	code1	code2	code3	code4	code5	code6
A	3	508	120	325	633	573
M	416	146	631	184	643	771
W	511	45	730	307	79	715
S	636	303	647	75	558	330
R	61	150	98	459	433	799
O	557	445	156	383	131	323
D	402	472	61	58	162	739
X	743	70	249	776	229	648
Q	619	419	733	556	35	495
O	372	563	34	123	83	776
U	493	247	211	654	731	150
V	631	530	373	386	132	236
B	426	726	498	689	480	4
W	270	599	709	49	79	355

<tbody>
</tbody>

I like to have each customer on a row and their codes in rows as well instead of having them in columns as the picture below:

Customer code
A 3
A 508
A 120

and so on.

what is the best way to do this? i tried transposing but it's still a manual process.

Thanks!!

 

[sheetspread]

The reverse pivot table:

https://www.youtube.com/watch?v=xmqTN0X-AgY