Hi!

Try this:

=INDEX($A5:$A10,COLUMNS($A:A))

Copy across as needed.

Biff

"Bernard Modlinsky" <Bernard wrote in
message ...
I'm looking for a way to to quickly transfer data from cells in a column
in
one sheet of an excel workbook to cells in a row in another sheet of the
same
workbook. It's a simple matter if the cells in both sheets are in columns
as
you can just make the first cell equal the first cell of the column that
you
want the data to come from, and then drag and drop from that one down to
the
other cells in that column til you have transferred all the information
required. I haven't worked out how to do this when you are going from
column
to row or vice-versa. Anybody got any ideas, please.