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
Bookmarks