How can I take information in rows and transpose it into columns?

[Guest]

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]

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.