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

ArgumentRequired?What it does
vectorYesA single row or column of values.
wrap_countYesHow many values per row.
pad_withOptionalWhat 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)
ABCDE
1AnaAnaEast400
2EastBenWest350
3400
4Ben
5West
6350
=WRAPROWS(A1:A6, 3) Explain

Example 2 — A calendar-style grid

Lay 1–31 out seven to a row.

=WRAPROWS(SEQUENCE(31), 7, "") Explain

Common mistakes

  • #VALUE! errors. vector is a 2D range. Flatten it first with TOCOL.

Notes

Kyle Stott

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.