Flipping columns to rows

  • Thread starter Hinojosa via OfficeKB.com
  • 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?
 
B

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IS there a way to invert rows? 2
Excel Fit to page print options in Excel 1
columns to rows flip 3
Flipping data - columns to rows and visa versa 2
Flipping numeric values 3
Merging multiple columns into one column (dynamically) 1
Color changing VB Code 0
counting blank cells within two columns 2

Top