Duplicating records by a quantity

**nd2006** · 03-12-2007, 12:45 PM

Hi all,

I have a spreadsheet with a set of stock data in it, and i need to split down the stock records by quantity to create individual records for each item for example:

Q Item
2 Pen
3 Pencil
1 Ruler

would become:

Pen
Pen
Pencil
Pencil
Pencil
Ruler

Thanks for the help on the last question which was similar, hoping this is possible too as i dont want to do it all by hand with over 3000 records to split!

Thanks in advance,

Nick

**starguy** · 03-12-2007, 01:12 PM

Originally Posted by nd2006

Hi all,

I have a spreadsheet with a set of stock data in it, and i need to split down the stock records by quantity to create individual records for each item for example:

Q Item
2 Pen
3 Pencil
1 Ruler

would become:

Pen
Pen
Pencil
Pencil
Pencil
Ruler

Thanks for the help on the last question which was similar, hoping this is possible too as i dont want to do it all by hand with over 3000 records to split!

Thanks in advance,

Nick

see the attached file, it may help you

**jetted** · 03-12-2007, 01:30 PM

Nice work starguy, will be helpfull for also

**nd2006** · 03-13-2007, 07:10 AM

Thanks for your help starguy, that is a useful method but i was hoping there would be an easier alternative, as that still means a huge amount of work.

Preferable would be some kind of macro or VB script that went through the sheet and copied each row and pasted it in underneath the required no. of times from the quantity field.

Is this possible?

Thanks
Nick