Hi,

There are many ways to transpose a row to a column:

1. You can use the Edit, Paste Special, Transpose command
2. You can use the TRANSPOSE array formula (note to do this the formula
requires array entry, for example you would highlight A1:A10, type the
formula =TRANSPOSE(B1:M1), and press Shift+Ctrl+Enter
3. You can use INDEX or OFFSET

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"MRAWLS" wrote:

I've been doing this in my spreadsheet but suddenly it is not working.