Transposing Rows and Columns

Contact Us or call 1-877-932-8228
Transposing Rows and Columns

Transposing Rows and Columns

You may at times determine that data you have already entered in a worksheet would be presented more logically by transposing rows and columns.

To transpose rows and columns:

  1. Select the cells with the headings and the data that you want to flip.
  2. On the HOME tab, in the Clipboard group, select Copy.
  3. Place your cursor in a blank cell in the worksheet, which will become the top-left cell in the transposed group.
  4. Right-click and select the Paste Special arrow, and then click Paste Special.
  5. In the Paste Special dialog box, check the Transpose check box and click OK.
  6. The data now appears with the rows and columns swapped.
Next