You’ve set up your worksheet with all your row and column headings, and you’ve entered all your data. Then, you discover that it would look better if the rows were the columns and the columns were the rows.
You don’t need to re-enter all that data! There is an easy way to convert your rows to columns and vice versa using the Transpose feature in Excel. We’ll show you how.
Select the cells containing the headings and data you want to transpose.
Click Copy or press Ctrl + C.
Click in a blank cell on the spreadsheet. This cell will be the top, left corner of the new table of data.
Click the down arrow on the Paste button and select Paste Special from the drop-down menu.
On the Paste Special dialog box, select the Transpose check box so there is a check mark in the box and click OK.
The rows become the columns and the columns become the rows. The original set of data still exists. You can select those cells and delete the headings and data, if desired.
Isn’t that a lot easier and faster than retyping all your data?