Flipping columns to rows

[Hinojosa via OfficeKB.com]

Is there a way to flip the current columns that you have, so that they will
be rows?

 

[Bernard Liengme]

No, but you can "flip" cell contents using either the function TRANSPOSE
or COPY followed by Paste Special with Transpose selected.
best wishes

 

[JoeAdidas21]

Hi there,
Highlight the area to be changed from Columns to Rows.
Right-click in the highlighted area and select "Copy" from the menu options.
Go to another area of the worksheet... a blank area.
Right-click on that empty cell and select "Paste Special" and select
"Transpose" and then "OK".
You will now see a copy of your columnar data displaying in a row format.
Hope this helps,
Joe

 

[Hinojosa via OfficeKB.com]

Perfect!!!! exactly what i needed thanks both of ya'll!!