Friday, November 13, 2009

Transpose Columns in Excel

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.

No comments:

Post a Comment

How to Delete Blank Rows in Excel