Transposing Data from Rows to Columns
You’ve spent some time setting up a worksheet and now you realize that you really need some of the data in columns instead of rows. Don’t worry. There’s an easy way to do that. Just copy the values, select the new area where you want to paste them, and select the Transpose option when you paste the values.
Use the following procedure to transpose data.
Copy the range of cells you want to transpose. This feature will not work if you cut the cells.
- Place your cursor in the new location and right-click.
- Select Transpose from the Paste Options on the context menu.