In a new Sheet2,
Put in A1: =OFFSET(Sheet1!$A$1,INT((ROWS($A$1:A1)-1)/3),)
Put in B1: =OFFSET(Sheet1!$B$1,INT((ROWS($A$1:A1)-1)/3),)

The above "starting cell" formulas can be placed in any 2 starting cells
(next to each other) in the new sheet, not necessarily in A1 & B1, and
filled down from there.

Adjust the number "3" within the part: .. INT((ROWS($A$1:A1)-1)/3)
to suit as required. Eg: If we want each line to repeat 4 times, change the
"3" to "4", then just fill down to cover at least 4 x the number of lines in
the source data. And so on.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--