Iterate over columns with a fixed row

is it possible to iterate over columns with a fixed row/cell and to create a new column with the values. For example I want to create a column like that:

F1=A1
F2=B1
F3=C1
F4=D1

and so on

Solution

Write the formula

=MAX(OFFSET($A$1:$A$10000;0;ROW()-1))

in cell F1 and stretch it down.

The expression ROW()-1 will take the value 0 for F1, 1 for F2, 2 for F3, and so on, and the OFFSET() function uses these values to move from the range A1:A10000 to 0, 1, 2, and so on columns.