STACK.ROTATE
This function rotates the complete stack by Pos positions up or down.
Syntax
=STACK.ROTATE(StackRange, [Position], TargetRange)
Arguments
| Name | Type | Description |
|---|---|---|
| StackRange | Range | Range, where the source range items are added to. The first row of the StackRange is a title range and remains unchanged. |
| Position (optional) | Number | If Position equals 0 then stack is not rotated. If Position > 0 all rows are moved up and the first row becomes the last one (behind the last filled row in the range). If Position < 0 all rows move down and the last filled cell becomes the first row. Default value: 1 |
| TargetRange | Range | If TargetRange is specified, the first row (after rotation) is copied to the TargetRange. TargetRange must have two rows, the first row has labels also found in Stackrange (not necessarily all and maybe not in the same order!). The rotated values are copied to the matching columns in the TargetRange. Important: Before copying to the TargetRange all existing values in TargetRange are deleted (not the labels row!). |
Return
| Type | Description |
|---|---|
| Booelan or Error | TRUE, if no error occurred, otherwise error value. |
Examples
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Name | Age | City | Street |
| 2 | Maier | 43 | Sidney | Main Street |
| 3 | Miller | 53 | Sidney | South Street |
| 4 | Jones | 45 | Sidney | West Street |
| 5 | Maier | 35 | Sidney | High Street |
| Formula | Result | Comment |
|---|---|---|
| After calling STACK.ROTATE  |