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

Best Regards,
FARAZ A. QURESHI


"CKK" wrote:

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

--
CKKwok