Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Transpose Column to Row | Excel Worksheet Functions | |||
Transpose not working rows to columns | Excel Discussion (Misc queries) | |||
column 2 to transpose using column 1 as reference | Excel Discussion (Misc queries) | |||
transpose column to a row? | Excel Discussion (Misc queries) | |||
Excel 2002 transpose not working | Excel Discussion (Misc queries) |