Transposing Data using Offset function

I have data in a column format (eg Cell A1:A12)

It is possible for me to transpose the data into a row (cell C1:N1) using
the offset function?

--
sarah

Hi,

Try this formula:

INDEX($A$1:$A$12,COLUMN()-COLUMN($B$1),1)

If you need any further clarifications, please feel freeto contact me at
[email protected].

Regards,

"sarah" wrote:

> I have data in a column format (eg Cell A1:A12)
>
> It is possible for me to transpose the data into a row (cell C1:N1) using
> the offset function?
>
> --
> sarah

sarah wrote...
>I have data in a column format (eg Cell A1:A12)
>
>It is possible for me to transpose the data into a row (cell C1:N1) using
>the offset function?

You could.

C1:
=OFFSET($A$1,COLUMN()-3,0)

Fill C1 right into D1:N1. But it'd be more efficient to select C1:N1,
type the formula

=TRANSPOSE(A1:A12)

and press [Ctrl]+[Shift]+[Enter] to enter it as an array formula in
C1:N1. If you want to do it one cell at a time, use INDEX rather than
OFFSET.

C1:
=INDEX($A$1:$A$12,COLUMN()-2)

Fill C1 right into D1:N1.

Harlan,
You just made my day!
Thank you for posting this solution!!!