turn a column into a row or visa versa
 

I've tried searching for a way to do this, but to no avail...does this make
sense: I want to change a column into a row, or change a row into a column.
Essentially, I want to flip or rotate the column into a row...

Much Thanks,
Joshua Veit

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

Copy the data in the column.
Select where you want the data. You won't be able to paste over the
existing data.
Paste Special - Transpose ??

Is this something you want to do once, or repeatedly?

"Joshua Veit" <Joshua wrote in message
...
I've tried searching for a way to do this, but to no avail...does this
make
sense: I want to change a column into a row, or change a row into a
column.
Essentially, I want to flip or rotate the column into a row...

Much Thanks,
Joshua Veit

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.


http://www.microsoft.com/office/comm...lic.excel.misc

Eidt/paste Special/transpose


--
Flamikey
------------------------------------------------------------------------
Flamikey's Profile: http://www.excelforum.com/member.php...fo&userid=4612
View this thread: http://www.excelforum.com/showthread...hreadid=382592