If you just need the data in column A........

Select B2:AJ2 and copy.

Select A2 and Paste SpecialTransposeOKEsc


Gord Dibben Excel MVP

On Wed, 7 Dec 2005 17:18:55 -0600, "Fred Smith" wrote:

I have data in cells b2:aj2

I want to refer to these cells in a column from a2 down. I can manually type in:

A2: =B2
A3: =C2
A4: =D2

Rather than doing so, is there a formula I can type in once in A2 then copy
down?