Formula Transpose

[snax500]

In Excel2000, I have the following data in row 1 ( Cities )and formulas
(starting in row 2 that reference the cities) in :

A B C
1 NY LA SF

2 +A1

3 +B1

4 +C1


Is there an easy way make a formula in A2 that I can copy down.I have
many rows of this type of data.

Thanks

 

[Bob Phillips]

Select A1:C1 and copy

Select A2

Edit>Pastespecial and click Transpose

 

[snax500]

Thanks for the reply but I wanted a formula that I can use not just
copy paste.

 

[Morrigan]

A2 = OFFSET(A1,2-ROW(),ROW()-2)

In Excel2000, I have the following data in row 1 ( Cities )and formulas
(starting in row 2 that reference the cities) in :

A B C
1 NY LA SF

2 +A1

3 +B1

4 +C1


Is there an easy way make a formula in A2 that I can copy down.I have
many rows of this type of data.

Thank

 

[MrShorty]

How about the TRANSPOSE function? It's an array function, but it does
exactly what you want.

 

[Guest]

Could you give a little more information - what are you trying to accomplish?
What are the formulas?

 

[snax500]

Thanks Morrigan, your formula is exactly what I am looking for.