How to Convert Columns to Rows in Excel 2007

After entering data into a spreadsheet you might find that your columns would look better as rows, or your rows as columns. Instead of having to re-enter your data, Excel 2007 has a feature that allows you to convert your data from column view to row view. Rather than being a single button to push or an option to select, the conversion is accomplished through a special copy-and-paste feature.

...
You can convert your columns to rows.

Step

Select all of the cells in the columns you want to convert to rows.

Step

Click the "Copy" button in the upper-left corner of the program window.

Step

Select an empty cell anywhere outside of the columns you copied.

Step

Click the little arrow beneath the "Paste" button in the upper-left corner of the program window. This opens a menu. Click "Transpose."