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
.

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