To repeat row values, a specified number of times

[ramananhrm]

Hi,

I have a query in repeating the cell values based on the number specified in a cell. (Using Excel functions only)

I have also attached a sample file for the same.

Please help me out.

[XOR LX]

Hi,

One way. In D2 and copy down, array formula:

=IFERROR(INDEX($A$2:$A$5,MATCH(TRUE,MMULT(--(ROW($A$2:$A$5)>=TRANSPOSE(ROW($A$2:$A$5))),$B$2:$B$5)>=ROWS($1:1),0)),"")

Regards

[:) Sixthsense :)]

@ XOR LX,

Great Work without using any helper columns. Nice Solution

[XOR LX]

Thanks, Sixthsense!

[krkmyld]

It didnt works for me. Can you please put that formula in the sample excel file?

Thanks in advance.

[AlKey]

It didnt works for me. Can you please put that formula in the sample excel file?

Thanks in advance.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.