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:
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.
Controls recalculation of results
For more information, see: Recalculating Analysis Results
The data input range.
For help with range controls, see: Specifying Your Input Data
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.
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.
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.
Trim off empty rows and columns.
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:
Specify output range.
For help with the range controls, see: Output Results