Ask Your Question
0

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

asked 2013-11-14 21:53:43 +0200

AisIceEyes gravatar image

updated 2015-09-10 10:55:51 +0200

Alex Kemp gravatar image

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?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-14 15:15:28.083262

1 Answer

Sort by » oldest newest most voted
0

answered 2013-11-14 23:26:31 +0200

m.a.riosv gravatar image

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.

edit flag offensive delete link more

Comments

Thanks! That did the job :D

AisIceEyes gravatar imageAisIceEyes ( 2013-11-15 07:08:51 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2013-11-14 21:53:43 +0200

Seen: 46 times

Last updated: Nov 14 '13