Skip to Content

WRAPROWS

Wraps the provided row or column of values by rows after a specified number of elements

Syntax

WRAPROWS(vector, wrap_count, [pad_with])

Parameters

  • vector: Required. The vector or reference to wrap
  • wrap_count: Required. The maximum number of values in each row
  • pad_with: Optional. The value to pad with. Default is #N/A

Example

=WRAPROWS(A1:A12, 4)
Returns: ArraySince: Microsoft 365