Repetition of rows for given number of times in Excel

GOWTHAMRAJAN 1 Posts Friday January 12, 2018Registration date January 12, 2018 Last seen - Jan 12, 2018 at 07:51 AM
I want to know how to repeat the "N" Number of time in a row

For example:

SL.NO ITEM QTY NUMBER OF TIMES REPETITION
1 COPPER COIL 1000 5
2 ALUMINIUM COIL 2000 3


ANSWER:

1 COPPER COIL 1000
1 COPPER COIL 1000
1 COPPER COIL 1000
1 COPPER COIL 1000
1 COPPER COIL 1000
2 ALUMINIUM COIL 2000
2 ALUMINIUM COIL 2000
2 ALUMINIUM COIL 2000

THIS IS WHAT I NEED SO PLEASE HELP.
See more