one way
assuming your data is in column A and B and starts in A1
in C1 enter 1
in C2 enter = C1+B1
copy C2 and paste down to one row below your data

in sheet 2 in A 1
=if(row()<=product(Sheet1!B:B),index(Sheet1!A:A,ma tch(Sheet1!C:C,row()),"")
copy and paste down as far as needed


"Christopher Naveen" wrote:

Hi,

Good evening.

I am christopher frm India.

My challenge is :

For example I have 5 rows and 2 columns as mentioned below and now pls look
the "name" col and the 1st data is "A" and the count is "7" and now I need
the value "A" should be pasted 7 times in new sheet and again it should check
for the 2nd data ( i.e) "B" and the count is "2" so it shud paste the 2nd
data 2 times in the sheet where already u pasted the 1st data.

Name Count
A 7
B 2
C 3
D 4
E 8


Output shoud be

Name
A
A
A
A
A
A
A
B
B


Pls help. Eagerly waiting for ur reply.