Copying the data's

[Guest]

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.

 

[Guest]

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,match(Sheet1!C:C,row()),"")
copy and paste down as far as needed

 

[Guest]

oops!
second equation should have been
=if(row()<=sum(Sheet1!B:B),index(Sheet1!A:A,match(Sheet1!C:C,row()),"")

 

[Guest]

Hi,

I pasted the 2nd equation provided by u in sheet 2 but it is showing #N/A.
Pls advise.

-Christopher

 

[Guest]

check each of the sections by itself
=sum(Sheet1!B:B)
=match(Sheet1!C:C,row()),"")
=index(Sheet1!A:A,match(Sheet1!C:C,row())
to determine which is the source of the N/a

did column C show as numbers?

 

[Guest]

I am finding problem while using the below mentioned formula's
=match(Sheet1!C:C,row()),"")
=index(Sheet1!A:A,match(Sheet1!C:C,row())

Pls help.

-Christ

 

[Guest]

the match equation should have been
=match(Sheet1!C:C,row())
and the other
=index(Sheet1!A:A,match(Sheet1!C:C,row()))

 

[Guest]

Sorry.
I entered the same formula in sheet 2 cell A1 it is showing as #N/A. If u
dont mind can u pls send me the excel sheet which u tried.

My email ID : (e-mail address removed)

-Christ

 

[Guest]

I should have copied and pasted the formula rather than just typing it in. I
made multiple errors on my typed formula
try this one on sheet 2
=IF(ROW()<=SUM(Sheet1!B:B),INDEX(Sheet1!A:A,MATCH(ROW(),Sheet1!C:C)),"")

 

[Guest]

Hi,

Excellent!!!!!!!

now it is working fine. Thanks a lot for ur help and pls dont mistake me i
really cannot understand the formula which u given here first i want to know
abt the formula. Can u pls explain me abt this formula in brief.

-Christ,

 

[Guest]

the first section
=IF(ROW()<=SUM(Sheet1!B:B)
merely checks to see how any rows you need to go down
the second
,INDEX(Sheet1!A:A,MATCH(ROW(),Sheet1!C:C))
sets up the range to look at and uses the match funciton to determine if you
have goten to the next number yet. column C is the cumilatve summ of the
previous times numbers need to be added.
the third
,"")
just puts a blank cell when you are past the total numner of entries you
want/.