Sometimes data that you have in Columns may look better in Rows, or vice versa.
To transpose Columns to Rows (or Rows to Columns) in Excel, is very easy. To do this, follow these simple steps:
1. Highlight the data you wish to transpose.
2. Click the Copy button.
3. Click into an empty cell (Note: it must be in a location separate from your current data or you may run into problems).
4. Right-click and choose "Paste Special".
5. On the Paste Special sub-menu, click the "Transpose" check box and click OK.
Remember, for this to work your data must truly be in a data format. If there are Blank Rows or Columns and/or the data is all in One Column or Row, the Transpose feature will not know what to do with your data.
I often hear people say "I no longer see the Forward, Reply, and Reply to All buttons on my emails. How do I get this information back?...
This is the text version of a YouTube Live session of Go Ask Debbie: How to Delete Blank Rows in Excel. I thought I'd just do a quick ...
Since 1998, Google has been giving us Google Doodles. The first Google Doodle was in honor of the Burning Man Festival . It wa...