2.2.3.77 wtranspose

1 Menu Information
2 Brief Information
3 Additional Information
4 Command Line Usage
5 X-Function Execution Options
6 Variables
7 Description
8 Examples
9 Related X-Functions

Menu Information

Restructure: Transpose

Brief Information

Transpose the active worksheet

Additional Information

Minimum Origin Version Required: Origin 8 SR0, updated in Origin 8.5 SR0

Command Line Usage

1. wtranspose exchange:=1 col:=new type:=long;

2. wtranspose select:=1;

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display Name	Variable Name	I/O and Type	Default Value	Description
Input Worksheet	iw	Input Worksheet	<active>	Specify the worksheet to be transposed.
Transpose from Selected Cell	select	Input int	0	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.
Exchange Label With Data	exchange	Input int	1	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.
Label Type	type	Input int	invalid	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 invalid:None No label rows will exchanged with a data column. long: Long Name The Long Name label row. unit:Units The Units label row. comment:Comments The Comments label row. rate:Sample Rate The Sample Rate label row. para:Parameter The Parameter label row. ud:User Define The first user-define parameter row label row. all:All All the label rows.
Data	col	Input int	new	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: new Column Creates a new column to the leftmost 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	ow	Output Worksheet	<input>	Specify the destination for the transposed worksheet. See the syntax here.

Description

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.

Examples

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:

Make the worksheet active and select Worksheet: Transpose from the menu.
Select Long Name with the Data Type drop-down list.
Click OK to close the dialog.

The result worksheet is as follows:

Related X-Functions

mtranspose