Help creating columns based on count

[wings516]

So I have a label name and count name in the row next to it, I need to be able to take the label name and create "count" amount of times in one column, and I need to do it for all of the labels. Here is a screenshot of an example. I have about 4000 of these labels...

So basically, as an example, take the text in A2, looks at B2, C2 or D2 and create that many copies of the text into column form based on the count number.

It absolutely HAS to be in one column for my labeling software to process the data. Maybe I create a separate page to create multiple columns of the labels and then concatenate them into one page as a single column? I don't know...

Thank you so much for the help! This will save me COUNTLESS hours!

 

[Snakehips]

wings516,

Welcome to MrExcel.

Here is a small piece of code that should hopefully do as you ask.
It does however assume that there is only one quantity in columns B,C or D.
It could be modified to add quantities if you wish.

In your example row 37, column D has value 2GF currently, that would be ignored and the label qty would be assumed to be 5.

Right click your sheet tab >> View Code >> paste the below code into the code pane.

Sub Label_List()
lr = Cells(Rows.Count, 1).End(xlUp).Row
Set Rng = Range("J1")
For r = 2 To lr
n = WorksheetFunction.Max(Range("B" & r & ":D" & r))
For i = 1 To n
Rng.Offset(i, 0) = Range("A" & r)
Next i
Set Rng = Rng.Offset(n, 0)
Next r
End Sub

Run the code by whatever means you wish e.g. for starters Alt+F8 select Label_List and run.

Hope that helps.

 

[wings516]

lol... and here I was trying to use the standard excel functions...

If I could donate to you, I would be more than happy to... You may/may not be able to comprehend how many hours of copy and pasting you just saved me!!!!!! Works like an absolute charm, it even cuts out the Chars in the count area and only looks at the number... I would have NEVER thought of that code...

 

[Snakehips]

You are most welcome.

Thanks for the feedback. If you are minded to toss a dollar into the next charity tin that gets rattled under your nose then so be it.