I know that I wouldn't/couldn't do it using a formula, but a small macro could
do it.
If you want a macro:
Option Explicit
Sub testme()
Dim FirstRow As Long
Dim LastRow As Long
Dim iRow As Long
Dim oRow As Long
Dim wks As Worksheet
Dim TimesToRepeat As Long
Set wks = ActiveSheet
With wks
FirstRow = 1
LastRow = .Cells(.Rows.Count, "B").End(xlUp).Row
oRow = 1
For iRow = FirstRow To LastRow
TimesToRepeat = .Cells(iRow, "B").Value
If TimesToRepeat 0 Then
.Cells(oRow, "C").Resize(TimesToRepeat).Value _
= .Cells(iRow, "A").Value
oRow = oRow + TimesToRepeat
End If
Next iRow
End With
End Sub
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
Be aware that there is not a speck of validation in this routine. If you put
non-numeric values in column B, it'll blow up real good.
TUNGANA KURMA RAJU wrote:
col a col b col c
john 2 john
mary 3 john
cathy 0 mary
jones 4 mary
mary
jones
jones
jones
jones
col a and col b is my input.Is there any formula to get out put like col c.I
fave a big list of col a and col b.Please give me idea.
--
Dave Peterson