WRAPROWS Function in Google Sheets: Syntax, Examples & Troubleshooting
Turn a single list into fixed-width rows, choose padding deliberately and distinguish inserted padding from genuine missing entries.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: WRAPROWS lays out a single row or column as a new grid, filling each output row before starting the next. The wrap count is the number of values per row, not the number of rows to produce.
Availability and version history
- Introduced: Announced February 1, 2023; rollout paused February 22, resumed March 1, with access scheduled by March 14. Google release history.
- Availability: Documented in the rolling Google Sheets service. This guide covers ordinary worksheet formulas in the web workflow; it does not establish separate mobile or connected-database behavior.
- Checked: October 14, 2026, against the official WRAPROWS reference. Documentation and independent calculations; no native application execution.
Syntax and defaults
=WRAPROWS(range,wrap_count,[pad_with])
The input is a one-dimensional row or column. wrap_count sets the maximum entries in each output row; Google documents rounding a noninteger count down to a whole number. Omitted pad_with fills unused trailing positions with #N/A. Supply a different value when the display needs an explicit placeholder.
Use a positive integer count for predictable layouts. The examples do not claim native error codes for zero, negative or invalid counts. Wrapping changes arrangement; it does not sort, deduplicate or match entries by a key.
Prepare a seven-item list
Enter these text labels in A2:A8, one per cell: Pen, Pad, Box, Tape, Clip, File, Glue. Keep the formula and all expanded results outside the source column. The order is deliberately not alphabetical.
Example 1: three items per row
=WRAPROWS(A2:A8,3)
The exact output is three rows by three columns:
| Pen | Pad | Box |
| Tape | Clip | File |
| Glue | #N/A | #N/A |
There are seven real entries and nine output positions. Two positions need padding. The last two #N/A values are the documented default padding, not evidence that Glue was missing or a lookup failed.
For a list of length seven and width three, two full rows contain six entries; the remaining entry needs a third row. The grid has no automatically generated headings.
Example 2: label unused positions
=WRAPROWS(A2:A8,3,"Unused")
The first two rows are unchanged. The final row becomes Glue, Unused, Unused. The placeholder is inserted only where the wrapped list runs out; it is not a general replacement for errors or blank values already present in the input.
Using "" instead makes the two padding positions display as empty text. They remain part of the calculated result, so do not assume they are genuinely empty worksheet cells. For auditing, a visible word can make unused slots easier to distinguish from accidentally omitted data.
Advanced example: compare layouts without changing the list
=WRAPROWS(A2:A8,2,"-")
=WRAPROWS(A2:A8,4,"-")
Place these formulas in separate output regions. Width two produces Pen,Pad / Box,Tape / Clip,File / Glue,-, a four-by-two array. Width four produces Pen,Pad,Box,Tape / Clip,File,Glue,-, a two-by-four array.
The seven labels stay in the same reading order. Only line breaks and the number of unused trailing positions change. This is useful for a compact review sheet or label mock-up, but printed page size and cell formatting still need to be configured separately.
The documented rounding rule also means =WRAPROWS(A2:A8,3.8,"-") uses width three. Prefer writing 3 explicitly when that is the intended layout; an unexplained decimal count can hide an upstream calculation mistake.
Example 3: reshape generated values
=WRAPROWS(SEQUENCE(7),3,0)
The result is 1,2,3 / 4,5,6 / 7,0,0. The two zeros are deliberately supplied padding, not original sequence values. A later total happens to stay 28, but a later average over all nine cells would include those zeros and become 28/9 instead of 4.
Choose padding according to downstream use, not just appearance. SEQUENCE generates the seven source values; WRAPROWS supplies the layout.
Troubleshooting and verification
Reserve every output cell, including padded cells. Keep a real two-dimensional table out of the input unless you first choose a deliberate flattening order with TOCOL or TOROW. Reading order matters when rows represent records.
Check the list order, wrap count and final incomplete row before changing error handling. All grids above were independently arranged from the supplied labels and numbers; they are expected results, not native Sheets observations. Examples use English-locale comma separators. For a vertical-first layout, the separately documented WRAPCOLS function uses a different filling direction.