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.

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.

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

"bj" wrote:

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.

Hi,

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

-Christopher

"bj" wrote:

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

"bj" wrote:

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.

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?

"Christopher Naveen" wrote:

Hi,

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

-Christopher

"bj" wrote:

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

"bj" wrote:

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.

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

"bj" wrote:

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?

"Christopher Naveen" wrote:

Hi,

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

-Christopher

"bj" wrote:

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

"bj" wrote:

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.