duplicate rows according to other column

Hi,
Say I have a table with 2 columns (item, quantity) and there are no duplicate rows. I need to duplicate a row according to the value that is in the quantity field... so if there is (table, 3) I need:

table, 3
table, 3
table, 3
...

is it possible to do this without manually inserting the row 3 times?

thanks.

Originally Posted by oldchippy

Hi,

Welcome to the forum, if you select your first two cells table, 3, then hold the Ctrl key and select the little black square (fill-handle) and auto-fill down

thanks for your help but is there not a more automatic way, only there are over 450 rows to this table....