turn a column into a row or visa versa

[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/comm...lic.excel.misc

[Flamikey]

Eidt/paste Special/transpose

[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" <Joshua [email protected]> wrote in message
news:[email protected]...
> 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