Need to add value of 1 to consecutive cells entire column BUT copy too

[SLINDSAY]

Sorry...it's hard to explain in the title. I appreciate any help here, thank you.

Here's what I am trying to do...I know how to add value of 1 to a cell and copy it down the column, but how do I add it to entire section of cells? Each number needs to be listed 10 times. Am I making sense? I have to do this down the column to 500+. Thanks again.

Column 1

1(1st row)
1(2nd row)
1
1
1
1
1
2
2
2
2
2
2
2
3
3
3
3
3

[Ace_XL]

In A1 input 1

In A2
=IF(COUNTIF(A1:$A$1,A1)>9,A1+1,A1)

Copy down

Change highlighted value as paer requirement

[SLINDSAY]

Thank you Ace_XL!!!! You saved me so much time and frustration. Have a great day.

Sarah