Macro Help - Transpose Quantity and QTR (Large amount of data)

[tommiexboi]

Hello,

Basically, I have over 1200 part numbers and I'm looking at an 8 quarter forecast.
I am trying to get the below result that will be quick and efficient. Would like to be able to sort by quarter and etc.

Any help will be greatly appreciated.


Current:
[TABLE="class: grid, width: 598"]
<tbody>[TR]
[TD]Part Number[/TD]
[TD]QTR 1[/TD]
[TD]QTR 2[/TD]
[TD]QTR 3[/TD]
[TD]QTR 4[/TD]
[TD]QTR 1[/TD]
[TD]QTR 2[/TD]
[TD]QTR 3[/TD]
[TD]QTR 4[/TD]
[/TR]
[TR]
[TD]ABC123[/TD]
[TD]67[/TD]
[TD]8[/TD]
[TD]8[/TD]
[TD]3[/TD]
[TD]1[/TD]
[TD]3[/TD]
[TD]0[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]10[/TD]
[TD]4[/TD]
[TD]2[/TD]
[TD]6[/TD]
[TD]0[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]ABC125[/TD]
[TD]3[/TD]
[TD]5[/TD]
[TD]12[/TD]
[TD]5[/TD]
[TD]3[/TD]
[TD]9[/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

Result Needed:
[TABLE="class: grid, width: 360"]
<tbody>[TR]
[TD]Part Number[/TD]
[TD]Quarter[/TD]
[TD]Quantity[/TD]
[/TR]
[TR]
[TD]ABC123[/TD]
[TD]QTR 1[/TD]
[TD]67[/TD]
[/TR]
[TR]
[TD]ABC123[/TD]
[TD]QTR 2[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]ABC123[/TD]
[TD]QTR 3[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]ABC123[/TD]
[TD]QTR 4[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]ABC123[/TD]
[TD]QTR 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]ABC123[/TD]
[TD]QTR 2[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]ABC123[/TD]
[TD]QTR 3[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]ABC123[/TD]
[TD]QTR 4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 3[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 1[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 2[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 3[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 4[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 2[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 3[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 1[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 2[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD]ABC124[/TD]
[TD]QTR 4[/TD]
[TD]3[/TD]
[/TR]
</tbody>[/TABLE]

 

[Peter_SSs]

Thank you all!

I really appreciate your help!!

You're welcome. Thanks for the follow-up.

 

[alansidman]

A very good primer is "M is for (Data) Monkey by Ken Puls and Miguel Escobar. Available on Amazon.