Could anybody tell me if it is possible to write in a Formula that will
duplicate the row by a set number of times.

I have a spreadsheet where I need to duplicate each row upto 2,000 times,
rather than copying the row and pasting it into 1,999 highlighted Rows does a
formula exist to perform such a task?

With my basic excel knowledge I imagine it looking something likk this -
=DUPLICATE(R2x1999) but obviously that doesn't work.

Please help to save me hours of work related boredom.
--
James Dawson