Reshape

<< Click to Display Table of Contents >>

Navigation:  Reference > Transforms >

Reshape

Description

Change the number of columns and rows.

 

Example

Change from 3 columns x 2 rows to 2 columns x 3 rows:

 

Reshape dataset

 

Inputs

One.

 

Options

Set Number of columns to the new number of columns you want to have. The number of rows will be calculated automatically.

 

Notes

Any extra values added will be set to empty. E.g. If 7 columns x 3 rows is reshaped into 4 columns x 6 rows, the 3 new values will be set to empty.

To get the effect you want, you may need to add empty columns with New Col, before Reshape.

 

See also

Concat Rows

Split Rows