Hi,
Not sure how i can do this. I have a large database (xls) with lots of columns and rows. In one of the columns there i a number which represents how many copies there are of the row. Looks like this:

[moe] [joe] [3] [foe] [boe] [...]
[woe] [doe] [7] [hoe] [soe] [...]


I have to turn these rows into this (copied x times down according to number in colum, in this example = 3 and 7):

[moe] [joe] [3] [foe] [boe] [...]
[moe] [joe] [3] [foe] [boe] [...]
[moe] [joe] [3] [foe] [boe] [...]
[woe] [doe] [7] [hoe] [soe] [...]
[woe] [doe] [7] [hoe] [soe] [...]
[woe] [doe] [7] [hoe] [soe] [...]
[woe] [doe] [7] [hoe] [soe] [...]
[woe] [doe] [7] [hoe] [soe] [...]
[woe] [doe] [7] [hoe] [soe] [...]
[woe] [doe] [7] [hoe] [soe] [...]

...and there are about 1500 rows of this....

It will take a lot of time to do this manually so i am wondering if there is an easier way of doing this?

Thanks, and what a great forum!

David