VB Code to arrange data in Table format

Hello:

Please refer to attached file.
I have data as shown in sheet.
I need VB Code to rearrange these data in Table format as shown from Row 21 down for all stores.
I have manually done for one product ID 22123.


Each item in column A Cell A3 thru A12 has 2 rows
Row 3,5,7,9 and 11 has Qty Sold
Row 4,6,8,10 and 12 has Qty on Hand.
Each Item has ProdID in column C as shown.
Each store has data for size shown in row 2.
Store Name is in row1.


Let me know if you have any questions.
Thanks.

Riz