If you need to convert a row of data in Excel into a column, there’s an easy way to do it. Follow these steps:
- Select the row of data that you want to convert into a column.
- Click the “Columns” tab on the ribbon and select “Convert Row To Column.”
- The “Convert Row To Column” dialog box will appear. In the “Type” field, select “Column.” In the “Width” field, enter the number of columns that you want to create from the row of data. In this example, we want to create two columns from the row of data so we enter 2 in the field. Click OK to complete the conversion process. ..
You’ve set up a worksheet, when you realize it would look better if the rows and columns were reversed. There’s no need to re-enter all that data. Just use Excel’s Transpose feature.
Select the cells containing the headings and data you want to transpose.
Click the “Copy” button or press Ctrl+C to copy the selected cells.
Click a blank cell where you want to copy the transposed data. The cell you select becomes the top, left corner of whatever you’re copying.
Click the down arrow under the “Paste” button, and then click the “Transpose” button on the dropdown menu.
Just like that, your rows become columns and your columns become rows—complete with any formatting you’d already applied to the original selection.
Note that your original, pre-transposed data still exists. You can select those cells again, and delete them if you want.
It’s a quick trick, but it sure is a lot quicker and easier than retyping all your data and formatting those rows again.
