Fill rows in columns

[Bruce]

Help. This is my first posting and I can't get a reply.
Can anybody help, please? I need to solve problem I have
for client I assist.

I want to autofill row cell contents A3,B3,C3,D3 in
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.?

 

[Frank Kabel]

Hi
=OFFSET($A$3,0,ROW(1:1)-1)