I have a data like below:

A 10
B 15
C 7
D 9
etc.

I want to copy each row with '1' one after another.
Like A will be copied from row 1 to 10 & then B will be copied from 10 to 25
and then C will be copied from row 25 to 33 and so on.

Suggest me a single formula for the same.

Pushpendra