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?
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?