How to transpose excel data?

[deadeye123]

the way i have it displayed is like below:


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


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