Restructure: Transpose
Transpose the active worksheet
Minimum Origin Version Required: Origin 8 SR0, updated in Origin 8.5 SR0
1. wtranspose exchange:=1 col:=new type:=long;
2. wtranspose select:=1;
Please refer to the page for additional option switches when accessing the x-function from script
Input
Worksheet
Specify the worksheet to be transposed.
int
This is only available when the Exchange Label With Data check box is not selected. It specifies whether or not to transpose only a region of the worksheet, where the selected cell of the top-left corner of the region. When this check box is selected, the cells above or to the left or the selected cell will not be transposed. Otherwise, the whole worksheet will be transposed.
This is only available when the Transpose from Selected Cell check box is not selected. It specifies whether to exchange the column label row selected in the Label Type drop-down list with the data column selected in the Data drop-down list.
This is only available when the Exchange Label With Data check box is selected. It specifies the column label row that will be exchanged with the data column selected in the Data drop-down list. Option list
This is only available when the Exchange Label With Data check box is selected and the Label Type drop-down list is not None. It specifies the data column that will be exchanged with the column label row selected in the Label Type drop-down list. Option list:
Output
Specify the destination for the transposed worksheet.
See the syntax here.
This X-Function can be used to transpose worksheet data.
The whole worksheet can be transposed, or you can opt to transpose only part of the worksheet. In the latter case, select the worksheet cell that locates in the top-left corner of the part to be transposed before bringing up the dialog. Make sure the Transpose from Selected Cell checkbox is selected and click OK in the wtranspose dialog.
Note: A worksheet with columns of different types cannot be transposed.
Suppose you want to transpose the following worksheet and rearrange the content in the long name row as a new column:
You can do the following:
The result worksheet is as follows:
mtranspose