Copy some information from sheet1 to sheet2
I have the following information on the sheet1
Products Color Quantity
Bike Blue 3
Chair Yellow 2
Table Brown 4
.....
What I want is to copy above information to the sheet2 according to the
number of quantity. In above example, the sheet2 should contain the infor
as;
Products Color Quantity
Bike Blue 3
Bike Blue 3
Bike Blue 3
Chair Yellow 2
Chair Yellow 2
Table Brown 4
Table Brown 4
Table Brown 4
Table Brown 4
.....
Could someone help me out. Thanks
J
|