4.6.6 Transposing Worksheets


Origin has a tool for transposing worksheet data. If the worksheet contains more row values than columns, Origin adds the needed columns during the transpose process. Origin names these added columns alphabetically, starting with the first letter that is not already used as a worksheet column name. The wreducerows dialog box uses the wreducrows X-Function.

To open the tool:

  1. Activate the workbook.
  2. Click Restructure: Transpose... and open the wtranspose dialog box, which utilizes the wtranspose x-function.

To transpose only part of the worksheet, select the upper-leftmost worksheet cell before opening the dialog box. Make sure the Transpose from Selected Cell box is selected before clicking OK.

Note: To transpose the columns and rows in your worksheet, all columns in the worksheet must be of the same Format type. For example, each of the columns must be set to Text & Numeric or Numeric. The column Format is set from the Format drop-down list in the individual column's Properties dialog box (The Options node). Double-click on a column heading to open the column's Properties dialog box. In the default Origin worksheet, each column is set to Format = Text & Numeric.

Dialog Options

Recalculate

Controls recalculation of results

  • None
  • Auto
  • Manual

For more information, see: Recalculating Analysis Results

Input Worksheet

The data input range.

For help with range controls, see: Specifying Your Input Data

Transpose from Selected Cell

Only available when the Exchange Label With Data check box is cleared. Used to transpose only a portion of the worksheet (where you have selected the cell in the top-left corner of the portion to transpose). When enabled, the cells above or to the left or the selected cell will not be transposed.

Exchange Label With Data

Only available when the Transpose from Selected Cell box is cleared. Exchange the column label row selected in the Label Type drop-down list with the data column selected in the Data drop-down list.

Label Type

Only available when the Exchange Label With Data check box is selected. Specifies the column label row that will be exchanged with the data column selected in the Data drop-down list.

  • None
No label rows will exchanged with a data column.
  • Long Name
The Long Name label row.
  • Units
The Units label row.
  • Comments
The Comments label row.
  • Sample Rate
The Sample Rate label row.
  • Parameter
The Parameter label row.
  • User Define
The first user-defined parameter label row.
  • All
All label rows.
Remove Ending Empty Rows and Columns

Trim off empty rows and columns.

Data

Only available when the Exchange Label With Data check box is selected and the Label Type is set to something other than None. Data column will be exchanged with the column label row selected in the Label Type drop-down list:

  • New Column
Creates a new column to the left-most position of the worksheet with Y column designation and exchanges it with the selected column label row.
  • First Column
Exchanges the first data column with the selected column label row with X column designation. The Label Type cannot be Sample Rate. Note: the leftmost cell of the column label row will be excluded in the exchange.
Output Worksheet

Specify output range.

For help with the range controls, see: Output Results

English | Deutsch | 日本語