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

G

Glenn

MRAWLS said:
I've been doing this in my spreadsheet but suddenly it is not working.
Click to expand...

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.
 
S

Shane Devenshire

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"The object was saved in an invalid format and cannot be read." 0
Continues to move to the right 0
Need Help with a VBA subroutine 0
Need transpose? help.... 9
LINEST multiple known_x's separated arrays 5
Eliminate blanks while copy row and transpose 11
Copying formulas in Columns and transpose to rows? 5
Alternate Row Shading with Filter 1

Top