Repeating an ID in multiple cells dependent on another cells value

Hello all, this is my first post, so I'm sorry if there is a thread here that addresses my questions. I could find anything to answer, so hoping someone can help :-)

I have a hotel ID for a property lets say 1234 is the ID (column A). In the same row there are values for the number of videos associated (column B) let's say 10 and values for the number of photos associated let's say 5.

I would like to repeat the ID 1234 in separate cells creating a vertical series of the same ID 10 times. I will use the concatenate function to build the proper URLs to the videos. Of course I will have a list of 10,000 IDs and each will have varying number of videos associated with them. Any help would be greatly appreciated and thanks in advance!

Based on "bebo" example:

Try this "none arrary" formula

D2: =A2
D3: =IFERROR(IF(VLOOKUP(D2,A$2:B$4,2,)>=COUNTIF(D$2:D2,D2)+1,D2,INDEX(A$2:A$4,MATCH(D2,A$2:A$4,)+1)),"")

Normally Enter
copy down as far as needed

Bebo,

Thank you so much! The first part to my problem has been solved perfectly . I have a second part:
In the video column instead of using the IF function to reapeat "1" if there is a value I would like to have listed, begining from "0", the amount of times that ID appears. See attached example:

Any help is greatly appreciated!

Thanks you all, worked great. Fantastic resource and much appreciated!