Any advice on how to convert a small table to an expanded version?
The title doesn't likely describe the situation. Sorry!
I have a list of plant names and quantity of each I need to engrave on popsicle sticks with a laser engraver. The engraver needs a CSV file with each line being 1 stick's name - column A & B for the 1 or 2 lines of plant name.
So is there an easy way to take info like this:
Col A Col B Col C
Geranium 3
Virginia Bluebells 4
and make another sheet in a workbook that looks like this?
Col A Col B
Geranium
Geranium
Geranium
Virginia Bluebells
Virginia Bluebells
Virginia Bluebells
Virginia Bluebells
I could cut paste each name into the number of rows noted for that name. But while I list 2 types here and low quantity, it's actually dozens of names and quantities around 100.
THANKS!
[link] [comments]
Want to read more?
Check out the full article on the original site