transpose question

[helpplease!]

Hi,

A B C D E F G... AZ
X L M N O P Q...
X
...

here is my question: in col A, i need a formula to automatically display every other cell from row 1

eg, from above, col A would display:
M
O
Q
etc

ideally i would like to have a drop down formula so i don't have to manually enter in col A.

any help much appreciated!

thanks,

helpplease!

[mikerickson]

=INDEX($1:$1,1,2*ROW())

You may need to ajust 2 * (ROW()) + i, by changing i to make things come out just so.

The trick is that ROW() returns the row number of the cell, so it increases as you drag the formula down.

Index($1:$1,1,ROW()) will transpose row 1 into column A.
Index($1:$1,1,2*ROW()) catches every other cell in row 1, starting with B1
Index($1:$1,1,2*ROW()-1) every other cell, starting with A1
Index($1:$1,1,2*(Row()-1)) puts A1 in A2, C1 in A3,...

[helpplease!]

Wow... worked perfectly!

+rep if possible