Perhaps something like this:

With:
B1: Alpha
C1: Bravo
D1: Charlie
E1: Echo

A2: =INDEX($B$1:$E$1,ROWS($1:1))
Copy that formula down as far as you need.

In the above example, these values are returned:
A2: Alpha
A3: Bravo
A4: Charlie
A5: Echo

Is that what you're looking for?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"lhouck12" wrote in message
...
I have information in a single row. I want to create a formula and extend
it
to an entire column but I want the cell value in the formula to extend by
row.