1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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!

submitted by /u/MrShnatter
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#rows.com
#natural language processing for spreadsheets
#generative AI for data analysis
#financial modeling with spreadsheets
#Excel compatibility
#CSV file
#plant names
#laser engraver
#popsicle sticks
#quantity
#Excel
#workbook
#engrave
#names and quantities
#table conversion
#Col A
#Col B
#spreadsheet
#lines of plant name