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

  • Thread starter Thread starter MRAWLS
  • Start date Start date
M

MRAWLS

I've been doing this in my spreadsheet but suddenly it is not working.
 
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.
 
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
 
You must log in or register to reply here.

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

Need transpose? help.... 9
Copying formulas in Columns and transpose to rows? 5
LINEST multiple known_x's separated arrays 5
Transpose 2
Transpose multiple Columns to rows 8
Transposing data with Index function 3
Column To Rows 3
Reverse Transpose? 4

Back
Top