Tuesday October 6, 2015 at 10:00am
Say you have column headings:
Pink Blue
Green
that you want to change into row headings:
Pink
Blue
Green
Moving the data manually, one item at a time, would be a tedious process. To
save time, you can use the Paste Special command to quickly transpose
a column of data to a row of data, or vice versa.
To transpose rows and columns:
Copy the data in one or more columns or rows.
Before you paste the copied data, right-click your first destination cell (the
first cell of the row or column into which you want to paste your data), and
then click Paste Special. (or you can use the Edit menu to find Paste
Special)
In the Paste Special dialog box, select Transpose, and then click OK(You'll
find the Transpose check box in the lower-right corner of the dialog box)