deepcalc
DocsWRAPROWS

WRAPROWS

View as markdown/docs/functions/wraprows.md Ask Claude about this pageOpens Claude with this page's address

Wraps a row or column into a 2-D array by rows.

  • Excel: Verified match
  • Google Sheets: Verified match
  • Returns: Array

Examples

=WRAPROWS(A1:A6, 3)
A
1 10
2 20
3 30
4 40
5 50
Result 10

Syntax

WRAPROWS(vector, wrap_count, [pad_with])
vector
range required
wrap_count
number required
pad_with
any optional

Errors

#VALUE!
=WRAPROWS(A1:B2,2)
ARRAY_CONSTRAINTruncates a range to at most the given rows and columns. ARRAYFORMULAEvaluates an expression across a range (this engine already spills, so it is a pass-through for sheets compatibility). ARRAYTOTEXTConverts array to text representation. BYCOLApplies lambda to each column of array. BYROWApplies lambda to each row of array. CHOOSECOLSReturns the specified columns from an array.