WRAPROWS Function
Wraps a single list into rows of a set width.
Category
Lookup & Reference
Available in
Microsoft 365, Excel 2024
Returns
A spilled 2D array
Want to practice WRAPROWS in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox
Overview
WRAPROWS fills values across into rows, starting a new row every wrap_count items. It's the row-first twin of WRAPCOLS.
Great for turning a long single-column export into a proper table.
Syntax
=WRAPROWS(vector, wrap_count, [pad_with])
Arguments
| Argument | Required? | What it does |
|---|---|---|
| vector | Yes | A single row or column of values. |
| wrap_count | Yes | How many values per row. |
| pad_with | Optional | What to fill empty spots with. Defaults to #N/A. |
Examples
Example 1 — Rebuilding a table from a list
An export lists Name, Region, Sales one after another in a single column.
C1fx=WRAPROWS(A1:A6, 3)
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Ana | Ana | East | 400 | |
| 2 | East | Ben | West | 350 | |
| 3 | 400 | ||||
| 4 | Ben | ||||
| 5 | West | ||||
| 6 | 350 |
=WRAPROWS(A1:A6, 3) Explain
Common mistakes
- #VALUE! errors. vector is a 2D range. Flatten it first with TOCOL.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.