Learn how to Transpose Row to Column in Excel. Transpose converts horizontal row data sheets into vertical column style sheets and back.

The Transpose feature allows you to rotate data from columns to rows and vice versa from rows to columns without reentering any of the data.

Launch Excel. Open the Excel worksheet containing the cells you want to transpose. Select the block of cells to transpose with your mouse. Right-click the mouse and click on "Copy." Locate an ...