•1 min read•from 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?
Our take
Are you facing the challenge of transforming a small table of plant names and quantities into a detailed CSV for your laser engraver? You’re not alone—many encounter hurdles when converting concise lists into expanded formats. The good news is that with a few simple techniques, you can automate this process, saving time and effort. In this guide, we’ll explore effective methods to expand your data seamlessly, ensuring each plant name appears the correct number of times without the hassle of manual entry. Let’s dive in!
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Create a table that reflects only selected data?Hello! I have an excel sheet at work that customers use to order supplies from us. The supplies are all in a list with an empty cell next to each item where they fill in the quantity they want to order. This list is rather long, so to help out my techs, I was wanting to create a table that will automatically translate the data from items they want to order when they enter a quantity next to it. Like if I had a list of 50 items, and I put a quantity number next to number 24 and 48, only they would populate in a separate table (with the entered quantity). Essentially the example below: ID Description Qty 101 Item 1 102 Item 2 7 103 Item 3 104 Item 4 2 105 Item 5 ID Description Qty 102 Item 2 7 104 Item 4 2 Is this something I could do? submitted by /u/Mad-Dog-McCree [link] [comments]
- Is there a way for me to sort dates found across multiple columns into another set of columns and have the original column headers next to each sorted dates?I have a sheet that details my farming activity schedules. Each row represents individual plot of land (LandID#), while columns represents each farming activities (eg. seeding, thinning, pot-up, transplant, and removal). As I input the seeding date, all the other activity dates are populated. As I am growing many different types of crops, the quantity of varying dates is large. Using this sheet alone, makes it very difficult and tiring just to figure out what activity is next on schedule. I'm hoping that there is a way to present these dates in a manner that is more intuitive. Perhaps presenting these into 3 columns: Date, Activity, and LandID#. Then having the data sorted ascendingly by date. Or perhaps there is a better idea. Thanks in advance! submitted by /u/mtgoni [link] [comments]
- How to organize a sheet based on how many times a certain value in a column is duplicated, and have all other columns follow?Hope the title is descriptive enough... i feel like i always struggle to describe excel stuff efficiently. I am a complete excel beginner! So i have a dataset that is 3000+ rows long. For the sake of ease (and also to not share PHI), I made a shortened 27-row long example; this is what is shown in the screenshots. The data I'm working with is downloaded from a website we use to give people questionnaires. Sometimes, people do not have very straightforward answers to each question, so we type in "comments" in those cases to help clarify the exact answer participants gave. The data I'm working with lists the ID number we gave to each participant; the "variable" AKA the name of the question (tells me exactly which question it is in our questionnaire); which "session" AKA appointment the question is from (we repeat the questionnaire multiple times per participant throughout a year, some in-person, some over the phone); which coworker left the comment (commenter); and finally the actual comment itself. We are trying to see which questions/variables were given comments most often. This is a replica of what I have: https://preview.redd.it/9lvlnwplfgng1.png?width=1025&format=png&auto=webp&s=4716f993d500383af6307b8fb1724fef5b8626e1 This is what i WANT it to sort of look like: https://preview.redd.it/3d4w5a6ofgng1.png?width=980&format=png&auto=webp&s=dd32c658aceadd0afe5c427f0ec19177226d5081 In other words, I want: A count of how many times each type of variable repeats in the excel file. the dataset to be organized from which variable appears the MOST often at the top, and the ones that show up the LEAST at the bottom. to get rid of all rows that were for a "test" participant (notice the "test" rows 8, 18, and 26 in the first screenshot are gone in the second). to be able to find an exact question from the questionnaire website based on this sheet. for example, if I wanted to look more into the context behind row 5's comment, I would know to go to our questionnaire website, go to participant 111's questionnaires from the Lab 1 appointment and specifically look at the alcohol_amount1 question. In other words it is important to keep the participant number and session information. It doesn't need to look exactly like the second picture, that was just the first way to organize it that came to mind. As long as it fills the above requirements that all I need that's what matters. I was trying out pivot tables but I couldn't really get it to look in a way that made sense to me. I really don't know what else to do besides comb through all 3000+ rows one by one... sorry if any of this doesnt fit the exact posting rules. I tried. thanks for any help in advance🥹 submitted by /u/soupysyrup [link] [comments]