Autofill from column to row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a worksheet with data in a column and want the data on another sheet
in a row, sorted in another way. I tried to use autofill to get data from
every 25th cell in the column to the row on the other sheet, ['sheet 1'!F2"]
in cell B2, ['sheet 1'!F27] in cell C2, ['sheet 1'!F52] in cell D2 and so on.
Excel autofill wont understand what I want, is there any other way of solving
this?
 
One way

In the destination sheet:

Put in B2:

=OFFSET('Sheet 1'!$F$2,COLUMNS($A$1:A1)*25-25,)

Copy B2 across to D2

B2:D2 will return the desired contents, viz.:

in B2: ='Sheet 1'!F2
in C2: ='Sheet 1'!F27
in D2: ='Sheet 1'!F52
etc

(at intervals of each 25th cell down)
 
Back
Top