M
MRAWLS
I've been doing this in my spreadsheet but suddenly it is not working.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Glenn
MRAWLS said: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.
P
Pai
Need more Details
D
Dave Peterson
What are you doing? (be specific)
What doesn't work?
What doesn't work?
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
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