Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I take information in rows and transpose it into columns?
I actually looked in the Excel "Help" section and they told me to copy the
row I wanted to transpose and then use the "Paste Special" command. A dialog box with all these choices was supposed to come up and I was supposed to select the box "Transpose". The dialog box that came up did not look anything like the one in the "Help" response. It had no choices, no box to click called "Transpose" or anything. I don't want to have to re-type all this row information into columns by hand. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I take information in rows and transpose it into columns?
My guess is that you had two instances of excel running.
Close one of the workbooks (and that instance of excel). Then back to the remaining instance of excel and use: file|open to open the second workbook. Now try the Edit|Copy, then Edit|Paste special stuff. Lisa wrote: I actually looked in the Excel "Help" section and they told me to copy the row I wanted to transpose and then use the "Paste Special" command. A dialog box with all these choices was supposed to come up and I was supposed to select the box "Transpose". The dialog box that came up did not look anything like the one in the "Help" response. It had no choices, no box to click called "Transpose" or anything. I don't want to have to re-type all this row information into columns by hand. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
transpose data between columns, rows or cells | New Users to Excel | |||
How can I transpose rows to columns in a large worksheet? | Excel Discussion (Misc queries) | |||
Transpose rows to columns w/varying numbers of lines per record | Excel Worksheet Functions | |||
autofill information from rows to columns without using transpose | Excel Discussion (Misc queries) | |||
repeated transpose from rows to columns with unequal groups | Excel Discussion (Misc queries) |