View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christopher Naveen Christopher Naveen is offline
external usenet poster
 
Posts: 1
Default Copying the data's

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.