Hi,

I spent the whole day to figure out a formula that does exactly one thing: copy (from sheet1) and paste data (to sheet2) a number of times depending on a value in an adjacent column. I searched several forum site and stumbled upon a VBA codes but I prefer a formula.

For instance:

Sheet1
Product Code(A) Product Name(B) QTY(C) Price(D)
02362 USB Drive 3 $1.75
03516 HDD 2 $23.50
06251 HDD Enclosure 0 $25.25
07542 LCD Monitor 2 $125.25
09561 Asus Netbook 0 $150

In Sheet2, in columns A and B only, the following show be the results:
Product Code (A) Product Name (B)
02362 USB Drive
02362 USB Drive
02362 USB Drive
03516 HDD
03516 HDD
07542 LCD Monitor
07542 LCD Monitor

Can you please help me for the formula in column A and B in sheet 2 to get the desired results above?

Regards,
kolokoy