Repeating numbers

[shawzito]

Hi,

I have data that starts in B3 and goes down to B1097. I need the data stating in B3 to repeat itself once in its row so for example if B3 is 10, then B3 and C3 are both 10. The second row (B4) will then repeat itself 3 times), the third row (B5) will then repeat itself 4 times. This pattern will continue until it ends at B1097.

I'm not sure if there is an easier way to do it besides copying the data myself manually but if anyone has any suggestions i would appreciate it. Thanks!

I also attached an example of what i'm attempting to do. My data set is a lot bigger.

[mikerickson]

In C3, put the formula
=IF(COLUMN(A1)<=ROW(A1),B3,"")

and drag down/right