Autofill Problem

[Guest]

In a worksheet I have a single column of data (column A) with alternating data:
A1 = A
A2 = 1
A3 = B
A4 = 2
A5 = C
A6 = 3
Etc.

What I want is for this data to be represented in 2 columns:
C1 = A, D1 = 1
C2 = B, D2 = 2
C3 = c, D3 = 3

In C1 I enter the formula "= A1"
In C2 I enter the formula "= A3"
In C3 I enter the formula "= A5"

If I select all three of these cells, grab the autofill handle and extend
the progression, excel doesn't seem to get the calculation correct. I expect
C4 to contain the formula "= A7". What I get is: "= A4". I've tried using
larger ranges of entered information but no matter how much I enter before I
try the autofill, excel doesn't calculate the progression correctly.

Any ideas?

 

[Guest]

Not sure what causes this, but I get the same result. One quick way around it
is to start with '=A1, '=A3 and '=A5 and then drag it down. After that, use
replace to replace '= by = and you got your result.

 

[Guest]

in C1:

=INDIRECT("A" & (ROW()-1)*2+1)

in D1:

=INDIRECT("A"&ROW()*2)

Copy both down