This article describes the formula syntax of the ARRAY.SHIFT function.
Return shifted array.
ARRAY.SHIFT(array, n)
array is an array or handle to an array. n is the number of elements to shift.
If n > 0 then shift right. If n < 0 then shift left.