Transpose

Command

Edit Transpose

Description

Allows to convert rows to columns and columns to rows.

With the Transpose you can switch the orientation of data, either in a selected area, or in the complete spreadsheet.

Data from the top row of the area to transpose will appear in the left column of the transposed area, and data from the left column will appear in the top row.

When you want to transpose only a particular area of the spreadsheet, you first select this area with the mouse. In this case, the number of rows and the number of columns of the selected area must be equal (while selecting, this can be checked in the status bar).