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. Selected Cells
  2. On the HOME tab, in the Clipboard group, select Copy. Copy in Clipboard Group of Home Tab
  3. Place your cursor in a blank cell in the worksheet, which will become the top-left cell in the transposed group. Cell Position for Transposition
  4. Right-click and select the Paste Special arrow, and then click Paste Special. Paste Special
  5. In the Paste Special dialog box, check the Transpose check box and click OK. Paste Special Dialog Box
  6. The data now appears with the rows and columns swapped.Transposed Data
Next