Do you know how to convert columns to rows, or rows to columns? (13/32)

Sometimes you may want to convert the rows in your worksheets to columns and the columns to rows without altering the data. Doing it manually can be very time consuming, but Excel offers the Paste Special command, which allows you to automatically make such changes.

1. Select and copy the data you want from one or more columns or rows.
2. Before pasting it into the target cells, right-click the first target cell.
3. Select the Paste Special option, or, from the Edit menu choose Paste Special.
4. In the Paste Special dialogue box, select the appropriate options (all data in the row or column, formulas only, values only, etc.).
5. Check the Transpose check box located at the lower-right corner.
6. Click OK.

Make sure that columns or rows do not overlap, otherwise the action will not be performed and an error message will be displayed. The Paste Special command is available in Excel 2000 and later.

Next