I have four items in column "U" starting in row 6
Screwdriver
Hammer
Prybar
Wrench
Extension
In column "V" I have the amount for each of the items. (these values would be user input)
Here is the data
U V
Screwdriver 3
Hammer 4
Prybar 2
Wrench 3
Extension 2
Desired output would be:
Screwdriver
Screwdriver
Screwdriver
Hammer
Hammer
Hammer
Hammer
Prybar
Prybar
Wrench
Wrench
Wrench
Extension
Extension
I would like each item in column "U" to repeat in column "B" the number of times the user entered in column "V" Can anyone help?
Thanks
Bookmarks