How can I transpose reference cells by Auto-fill?

  • Thread starter Thread starter CKK
  • Start date Start date
C

CKK

Hi Folks,
for example, satrt from a reference =A1 then Auto-fill right (Ctrl+R), I can
get =B1, =C1...and so on, is there any easy way that I could got the same
result list in same column as:
=A1
=B1
=C1
....
but Auto-fill down (Ctrl+D) as;
=A1
=A2
=A3
....

What I'm doing now silly is to edit each cell =A$1, =B$1...copy...paste
special...transpose...
 
Your example was not too much clear but lets suppose your row 1:1 consist the
data that you want to transpose in column A2 and below as:
A1
B1
C1

then hopefully this formula, in cell A2 shall help:

=+OFFSET($A$1,0,ROW()-2)

Copy down as long as you want
 
another way
presume yr auto-filled area (=A1,=B1...) is in A2, B2,...
select $A$2:$H$2 area, go to formula bar and insert the formula (this
is an array formula so CTRL+SHIFT+ENTER it)

=TRANSPOSE($A$2:$H$2)
 
Back
Top