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

2.2.3.10 colsplit


Brief Information

Split column(s) into multiple columns by row index grouping

Additional Information

Minimum Origin Version Required:2015 SR1


Command Line Usage

1. colsplit irng:=col(A) nrows:=3;

2. colsplit irng:=col(B) method:=seq nrows:=10;

3. colsplit irng:=[Book1]Sheet1!(1,2);

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Column(s) to be Split irng

Input

Range

<active>

Specify the input data range, should be one or multiple data column(s).

Subgroup Method method

Input

int

0

Choose a method to subgroup, works together with the nrows variable (i.e. N will be the value defined by nrows).

Option list:

  • every:By Every Nth Row{0}
    Every Nth row will be considered as a group. For example, if nrows is 3, there would be 3 groups, the first group has the data from rows 1, 4, 7 ... 1 + 3 * M, the second group has the data from rows 2, 5, 8, ... 2 + 3 * M, and so on.
  • seq:By Sequential N Rows{1}
    The sequential N rows will be considered as a group. For example, if nrows is 5, the data from row 1 to row 5 will be the first group, from row 6 to 10 will be second group, and so on.
N nrows

Input

int

2

Specify the N value used in method variable. Based on the subgroup method chosen (method variable), it has different meanings.

Output rd

Output

ReportData

[<input>]<new>

Specify where to output the result, see syntax here.

Description

The concept of this X-Function is similar to wunstackcol, but the grouping is based on row indices.

Related X-Functions

wunstackcol

 

© OriginLab Corporation. All rights reserved.