Breaking out records based on qty

[jrock183]

Hi everyone,

I think what I want to do should be simple, but I can't figure it out so maybe you experts can help!!

I have a simple table, with 3 columns: sku, desc, and qty. I have about 5000 records with qty's from 1 to 100. What I need as a result is to read the qty field and produce that many sku's on different lines. Here is an example

beginning with:

sku desc qty
m51130 blue 2
m31131 red 5

to result in:

sku desc
m51130 blue
m51130 blue
m31131 red
m31131 red
m31131 red
m31131 red
m31131 red

Thanks in advance for your help!!!

[lecxe]

Assuming the table in columns A:C, the data starting in row 2, this code writes the result in E:F, starting in row 2.

Please Login or Register  to view this content.

HTH
lecxe

[jindon]

try

Please Login or Register  to view this content.