Macro - Combining Two Or More Lists Of Data In A Loop

I have 3 list of data and I need to combine them.

Item list (5 to 100 items in a list)Quantity listStore list (2 to 10 stores)

For every item in my list, I need to add the list of stores to distribute to, and the quantity needed.

Example of order sheet

Stores

Items
74
22
70
71
59

[Code] .........

I need a macro to convert the order array list into column form such as Items A, Store B and Qty C

Item
QTY
Store

1001
2
74

[Code] ......

I have been trying for 3 weeks different loop combinations.