Wauvel

Excel like a finance pro.

← The library

Dynamic array function

WRAPROWS

Wraps a single row or column into rows of a given width.

Rarely usedDifficulty 1450 · AdvancedUsage rank #114 of 520
Practice · 2 questions →

When to use it

Wraps a single row or column into rows of a given width. Turns a flat list into a grid.

The shape of it

Syntax
=WRAPROWS(vector, wrap_count, [pad_with])

Worked examples

  • Rows of two

    =WRAPROWS(SEQUENCE(6),2) → {1,2;3,4;5,6}

    Six values in rows of two.

  • With padding

    =WRAPROWS(A1:A7,3,"") → 3 columns, last cell blank

    Seven values in rows of three, padded.

  • Reshape a grid

    =WRAPROWS(TOCOL(A1:C4),4) → regridded 3 by 4

    Flatten then rewrap to a new width.

Worth knowing

  • Address labels from a single column: WRAPROWS(list,3).
  • Without a pad value, leftover cells are #N/A.
  • WRAPCOLS fills down instead of across.

Where it goes wrong

  • #VALUE! when the input is not a single row or column.
  • Requires Microsoft 365.

Related

FILTERSORTUNIQUESEQUENCESORTBYVSTACK

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.