turn a column into a row or visa versa

J

Joshua Veit

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/com...e-7452e2a67764&dg=microsoft.public.excel.misc
 
B

Barb Reinhardt

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 said:
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.
Click to expand...
http://www.microsoft.com/office/com...e-7452e2a67764&dg=microsoft.public.excel.misc
 
Top