Try...

A2, copied down:

=OFFSET($A$1,0,ROW()-ROW($A$2))

Hope this helps!

In article ,
"Shawn" wrote:

I have a spreadsheet where data is spread across Row 1:1.

I need a formula I can put in Cell A2 that will equal Cell A1. I then want
to drag that formula down so that Cell A3 will equal Cell B1 and Cell A4 will
equal Cell C1 and so.

In Excel, when you drag formulas down, it wants to update the formula down.
I need to drag the formula down, but for it to update the formula across. I
hope I am wording this correctly.