How to Convert Columns to Rows,
or Rows to Columns - Excel 2007 |
 |
|
Select and Copy the data in one
or more columns or rows.
Before pasting copied data,
right-click your first destination point (the first cell of the row or column
into which you want to paste your data), and then click Paste Special (Figure
1).
Figure 1
In the Paste Special dialog box,
select Transpose, and then click OK (Figure 2).
Figure 2 |
Site
Map
