Unsure how to describe - represent text n times?

[inneed]

Hi,

I have 2 columns of data - a list of text names and a list of the number of times they occur, like this example:

Name ___Coverage
cds a ___3
cds b ___2
cds c ___1
cds d ___0
cds e ___2


I'd like to get to a point where I have each text name represented the corresponding no. of times according to the coverage, like this:
cds a
cds a
cds a
cds b
cds b
cds c
cds e
cds e

...with each entry in a new cell.

Is this possible?? I'm using Excel 2010. I hope someone can help!

Thanks very much

 

[VoG]

Try this - results in column C

Sub ctest()
Dim LR As Long, i As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LR
    If Range("B" & i).Value > 0 Then Range("C" & Rows.Count).End(xlUp).Offset(1).Resize(Range("B" & i).Value).Value = Range("A" & i).Value
Next i
End Sub

 

[inneed]

That is amazing!! Works perfectly, thanks so much VoG!

 

[T. Valko]

Hi,

I have 2 columns of data - a list of text names and a list of the number of times they occur, like this example:

Name ___Coverage
cds a ___3
cds b ___2
cds c ___1
cds d ___0
cds e ___2


I'd like to get to a point where I have each text name represented the corresponding no. of times according to the coverage, like this:
cds a
cds a
cds a
cds b
cds b
cds c
cds e
cds e

...with each entry in a new cell.

Is this possible?? I'm using Excel 2010. I hope someone can help!

Thanks very much

Here's a formula method if you might be interested in that:

http://www.mrexcel.com/forum/showpost.php?p=2807560&postcount=8