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

Excel is equipped with several additional formula operators that will help you perform complex calculations. The formula =SQRT (A1) will calculate the square root of the referenced cell.

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.

Q: To make an Excel table fit better on a page when I print it, I frequently have to transpose it—that is, move all the data from, say, rows 1, 2 ...