blank rows between copied rows

Giganews Newsgroups
Subject: blank rows between copied rows
Posted by:  Arif
Date: Thu, 4 May 2006

hi, if i have 10 rows of data and would like to copy them into a new sheet
with a condition of 4 blank rows of each row data, so the second will be in
the $th row, and so on, how can i do this??

exmp:

before                                        after
12345 Andrew XXX YYY          12345 Andrew XXX YYY
12356 Andy TTT UUU              -
12675 Adro NNN MMM            -
13452 Budi LLL OOO                -
14567 Lory MMM PPP              12356 Andy TTT UUU
etc..

Any help would be appreciated..

Replies