Trying to transpose a row to a column - it is not working - help!
 

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

Trying to transpose a row to a column - it is not working - help!
 

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

Need to provide some details. List examples of your data, the exact steps you
are taking, the results you are getting and the results you expect.

Trying to transpose a row to a column - it is not working - help!
 

Need more Details


"MRAWLS" wrote:

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

Trying to transpose a row to a column - it is not working - help!
 

What are you doing? (be specific)
What doesn't work?

MRAWLS wrote:

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

--

Dave Peterson

Trying to transpose a row to a column - it is not working - help!
 

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.