Flipping columns to rows

  • Thread starter Thread starter Hinojosa via OfficeKB.com
  • Start date Start date
H

Hinojosa via OfficeKB.com

Is there a way to flip the current columns that you have, so that they will
be rows?
 
No, but you can "flip" cell contents using either the function TRANSPOSE
or COPY followed by Paste Special with Transpose selected.
best wishes
 
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
 
Back
Top