Say your "single" row is Row1, from A1 to IV1.

You can enter this formula *anywhere*, but for the sake of this demo, say
you enter it in A2:

=INDEX($1:$1,ROWS($1:2)/2)

NOW, select A2 *and* A3, with A3 being empty.

Click on the fill handle of that 2 cell selection and drag down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Excel Greenie" wrote in message
...
How do I copy a single row to every alternate row to the end of the
spreadsheet. Spreadsheet can vary in size. i.e. Can be 100 rows - 500
rows