Rows to columns

[Bruce]

I want to autofill row cell contents A3,B3,C3,D3 to
column cells E3,E4,E5,E6. I've used =OFFSET($A$3,0,ROW
(1:1)) but this puts B3 in E3. How do I modify to put A3
in E3, B3 in E4, etc.?

 

[Patti]

Do you mean transpose?

Hi-lighting Cells E3 through E6 and typing in the formula:

=transpose(A33)

and entering with CTRL-SHIFT-ENTER

 

[Domenic]

Hi,

E3, copied down:

=OFFSET($A$3,0,ROW()-3)

Hope this helps!