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:

Part Number	QTR 1	QTR 2	QTR 3	QTR 4	QTR 1	QTR 2	QTR 3	QTR 4
ABC123	67	8	8	3	1	3	0	4
ABC124	1	2	10	4	2	6	0	6
ABC125	3	5	12	5	3	9	3	3

<tbody>
</tbody>

Result Needed:

Part Number	Quarter	Quantity
ABC123	QTR 1	67
ABC123	QTR 2	8
ABC123	QTR 3	8
ABC123	QTR 4	3
ABC123	QTR 1	1
ABC123	QTR 2	3
ABC123	QTR 3	0
ABC123	QTR 4	4
ABC124	QTR 1	1
ABC124	QTR 2	2
ABC124	QTR 3	10
ABC124	QTR 4	4
ABC124	QTR 1	2
ABC124	QTR 2	6
ABC124	QTR 3	0
ABC124	QTR 4	6
ABC124	QTR 1	3
ABC124	QTR 2	5
ABC124	QTR 3	12
ABC124	QTR 4	5
ABC124	QTR 1	3
ABC124	QTR 2	9
ABC124	QTR 3	3
ABC124	QTR 4	3

<tbody>
</tbody>

 

[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.