Repeat number X amount of times

It looks easy, but I can't get my head around it. With a formula, I want to repeat a number X amount of times before going to the next consecutive number. Like this:

2
2
2
3
3
3
4
4
4
5
5
5
6
6
6


The starting number (in this case 2) is set in A1, the number of repeats (in this case 3) is set in A2.

Any idea?

Try in any cell and copy down

Formula:

Please Login or Register  to view this content.

Thanks! Worked great guys.