Skip to content
Google Sheets

WRAPROWS function in Google Sheets

Wraps the provided row or column of cells by rows after a specified number of elements to form a new array.

=WRAPROWS(range, wrap_count, [pad_with])

WRAPROWS syntax and parameters

Three arguments, two required.

  • rangerangeRequired

    The range to wrap.

  • wrap_countnumberRequired

    The maximum number of cells for each row. If the value isn’t a whole number, it’s rounded down to the nearest whole number.

  • pad_withanyOptional

    The value with which to fill the extra cells in the range. By default, the WRAPROWS function fills the extra cells with #N/A.

WRAPROWS examples

Formulas you'll actually reuse.

  1. Thirty daily values laid out as calendar-style rows of seven:

    =WRAPROWS(A2:A31, 7)

  2. Pad the short final week with blanks instead of #N/A:

    =WRAPROWS(A2:A31, 7, "")

WRAPROWS in Excel

Same name — your formula ports as-is.

Try WRAPROWS in the playground

Edit the example — nothing to install.

Preloaded with the WRAPROWS formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.