ROTATE_RIGHT

The number of columns to rotate to the right. This value must be a non-negative integer. The value of zero copies the rows without any rotation.

data

The numerical values to rotate to the right. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your IBM® product.

Description

ROTATE_RIGHT rotates the specified data range right by a number of columns. It returns one new column for each input column, each containing a copy of the corresponding input column rotated to the right by num_cols positions. Columns that are rotated off the right are wrapped around on the left.

ROTATE_RIGHT only works with numerical data. None of the data provided in the data parameter can be ASCII text.

Examples

TEMP = ROTATE_RIGHT(1, MERGE(1, 2, 3)

Creates three new columns named TEMP, VX, and VY. TEMP contains the value three, VX contains the value one, and VY contains the value two.

TEMP = ROTATE_RIGHT(0, V1:V3)

Creates three new columns named TEMP, VX, and VY. TEMP is a copy of column V1, VX is a copy of column V2, and VY is a copy of column V3.

TEMP = ROTATE_RIGHT(4, V1:V3)

Creates three new columns named TEMP, VX, and VY. TEMP is a copy of column V3, VX is a copy of column V1, and VY is a copy of column V2.

TEMP = ROTATE_RIGHT(1, V1[10:50]:V2)

Creates two new columns named TEMP and VX, each with values in the first 41 rows (the other cells are empty). The values in column TEMP are the values in rows 10-50 of column V2, and the values in column VX are the values in rows 10-50 of column V1.

Related Functions

Function	Description
ROTATE_LEFT	Rotates the columns in the specified data range to the left