This should be so simple, yet my brain cannot see it. Any help from you guys would be really appreciated

COL A has 1300 rows.
COL B is currently blank.

Need to fill every 10 rows in COL B with a value from 1 row of COL A, then repeat.

Result would look like this:

COL A (static values, but 1300 rows)
1
2
3
4
5
6
...

COL B (13,000 rows when completed)
1
1
1
1
1
1
1
1
1
1
1
1
2
2
2
2
2
2
2
2
2
2
3
3
3
3
3
3
3
3
3
3
...