Is there a way from 1st sheet in the same ods file, can be transposed into the 2nd sheet by 4?

[AisIceEyes]

Is there a way from 1st sheet in the same ods file, can be transposed into the 2nd sheet by 4?
Like the value to be displayed are like the following:

Sheet2.A1 = Sheet1.A1 , Sheet2.B1 = Sheet1.A2 ,  Sheet2.C1 = Sheet1.A3 ,  Sheet2.D1 = Sheet1.A4 
Sheet2.A2 = Sheet1.A5 , Sheet2.B2 = Sheet1.A6 ,  Sheet2.C2 = Sheet1.A7 ,  Sheet2.D2 = Sheet1.A8 
Sheet2.A3 = Sheet1.A9 , Sheet2.B3 = Sheet1.A10 , Sheet2.C3 = Sheet1.A11 , Sheet2.D3 = Sheet1.A12 

and so on?

[mariosv]

Hi AisIceEyes,

for the first column:

Sheet2.A1: =OFFSET(Sheet1.A$1;(ROW()-1)*4;0)

and copy down, adapt properly for the other columns.

[AisIceEyes]

Thanks! That did the job