# 2.2.3.10 colsplit

## Brief Information

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

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.