The way I have done this in the past is to copy A1 to A6, then to A11,
then to A16 etc then delete the rows between the cells you have copied
(i.e. 2:5, 7:10 etc). If you have a lot of blank rows to delete, you
can set up a filter, select Blank then Edit | Delete Row, then remove
the filter.

Pete