Attached are a couple screenshots. What I need to do is take sku numbers and break them out to quantities of one each, even when quantities are multiple. End goal is to set them up for importing and issue tracking numbers per each Qty. Example: ModelNo3 below at Qty=6, needs to break out to 6 rows of Qty=1 each. Where do I start with something like this?
Table: TempSku
Sku,Qty
ModelNo1,1
ModelNo2,1
ModelNo3,6
ModelNo4,4
Query Results Needed:
Sku,Qty
ModelNo1,1
ModelNo2,1
ModelNo3,1
ModelNo3,1
ModelNo3,1
ModelNo3,1
ModelNo3,1
ModelNo3,1
ModelNo4,1
ModelNo4,1
ModelNo4,1
ModelNo4,1
Thanks!