Offset Column takes the contents of a selected column and repeats it in a new column, offsetting the values by one row up or down.
Offset Column is useful for deriving the upper or lower bounds of a range, where only one of those values has been supplied. In this example, only the lower bound of the range has been provided in the ‘From’ column.
Input data |
|
ID |
From |
1 |
0 |
2 |
50 |
3 |
100 |
4 |
250 |
5 |
1000 |
To produce an upper bound in a ‘To’ column, the ‘From’ column is offset up one row and the blank value at the bottom is populated with the value 100,000. The first value in the ‘From’ column will be clipped off when data is offset into the ‘To’ column.
Output data |
||
ID |
From |
To |
1 |
0 |
50 |
2 |
50 |
100 |
3 |
100 |
250 |
4 |
250 |
1000 |
5 |
1000 |
100000 |
To use Offset Column:
Select the column that the new column will be derived from.
The new column containing the offset rows. Selecting an existing column name will overwrite that column.
The rows in the output column will be offset by one row. Select whether to offset them up or down.
Optional. If a value is entered here, it will populate the blank value created at the start or end of the new column.