How to Convert Columns to Rows,
or Rows to
Columns
in Excel 2003
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)
Site
Map
