OriginLab Corporation - Scientific Graphing and Data Analysis Software - 2D graphs, 3D graphs, Contour Plots, Statistical Charts, Data Exploration, Statistics, Curve Fitting, Signal Processing, and Peak Analysis

wunstackcol

Contents

Menu Information

Unstack Columns

Brief Information

Unstack grouped data into multiple columns

Additional Information

Minimum Origin Version Required: 8.1 SR0, updated in 8.5.1

Command Line Usage

  1. wunstackcol irng1:=2 irng2:=1 missing:=1;
  2. wunstackcol irng1:=col(2) irng2:=col(1) nonstack:=1 other:=col(3);
  3. wunstackcol -r 2 irng1:=(3:5) irng2:=col(2) sort:=data pos:=udl label:=L;

Variables

Display
Name 		Variable
Name 		I/O
and
Type 		Default
Value 		Description
Data to be Unstacked irng1

Input

Range

<active>
 Specify the data to be unstacked.
Group Columns irng2

Input

Range

<unassigned>
 Specify the data to be the group. Unstacking columns is in accordance with this group.
Include Other Columns nonstack

Input

int

0
 Specify whether to include those non-unstack columns in the original sheet to the result sheet.
Other Columns other

Input

Range

<optional>
 Specify the data range(s) which will be the non-unstack column(s) to output to the result sheet. It is available when Include Other Columns is checked.
Include Missing as One Group missing

Input

int

0
 Specify whether to consider missing values as one group.
Sort Output Coulmns By sort

Input

int

0
 Specify how to sort the output columns.

Option list:

  • group:Group Variables
    Sort the output columns by group variables. For example, suppose there are two groups named "Acura" and "Buick", after unstacking, the result column for "Acura" group will be on the left side of the one for "Buick".
  • data:Data to be Unstacked
    Sort the output columns by the data to be unstacked, depending on the order of the data specified in the Data to be Unstacked. For example, suppose there are two columns of data need to be unstacked, column 3 and column 4 in Sheet1 of Book1. Then if the ranges specified in Data to be Unstacked is [Book1]Sheet1!(3,4), after unstacking, the result columns from column 3 will be on the left side of those from column 4. Otherwise, if [Book1]Sheet1!(4,3), the result columns from column 4 will be on the left side of those from column 3.
Output Worksheet ow

Output

Worksheet

<new>
 Specify where to store the output unstacked results.
Put Grouping Info. to pos

Input

int

1
 Specify where to put the grouping information.

Option list:

  • lname:Long Name
    Put the grouping information to the Long Name row.
  • comments:Comments
    Put the grouping information to the Comments row.
  • append:Append to Data Column's Long Name
    Append the grouping information to the Long Name row.
  • udl:User Defined Parameters
    Put the grouping information to the user defined parameter row, this row's name is specified by From Group Columns.
From Group Columns label

Input

string

<unassigned>
This drop-down list is only available when Put Group Info. to is set as User Defined Parameters. It is used to name the user defined parameter row for storing grouping information. The name is from the label row of the Group column in the source worksheet. The selected label row must contain a string for naming the user defined parameter row, or there will be an error message. Please refer to Column Label Row Characters for the single character to specify a label row.

Related X-Functions

wstackcol

More Information

Please refer to this page in the User Guide for more information.