Reshape a List into a Grid (WRAPROWS)

Excel 365

WRAPROWS folds a long single column into a tidy grid of a chosen width — turning a 12-item list into a 4×3 layout, or a flat export into labels. WRAPCOLS does the same down columns.

Quick formula: to wrap a column into rows 3 wide:

=WRAPROWS(A2:A13, 3)

The second argument is the number of columns per row; WRAPROWS fills left-to-right, starting a new row every 3 values.

Functions used (tap for the full reference guide):

WRAPROWS WRAPCOLS

The example

A six-item list reshaped into a 3-wide grid.

	A	C	D	E
1	List	Wrapped (3 wide)
2	1	1	2	3
3	2	4	5	6
4	3 …

The formula

The list folded 3 per row:

=WRAPROWS(A2:A7, 3) // 1,2,3 then 4,5,6

How it works

WRAPROWS chops the list into fixed-width rows:

It takes the single column and lays values out across, starting a new row after every N values (here 3).
A six-item list becomes a 2-row × 3-column grid.
If the last row comes up short, the gaps are padded with #N/A — supply a third argument to use a different pad value.
WRAPCOLS does the mirror image, filling down columns of a chosen height.

The inverse of TOCOL. TOCOL flattens a grid to a column; WRAPROWS rebuilds a column into a grid. Together they reshape data into whatever layout you need — e.g. flatten, filter, then re-wrap.

Try it: interactive demo

Live demo

Wrap the list 1..6 into rows of N.

Columns per row

Variations

Wrap down columns

WRAPCOLS fills vertically, N tall:

=WRAPCOLS(A2:A13, 4)

Custom pad value

Use a blank instead of #N/A for short rows:

=WRAPROWS(A2:A13, 3, "")

Flatten then re-wrap

Reshape any block to a new width:

=WRAPROWS(TOCOL(B2:D10, 1), 4)

Pitfalls & errors

Short last row pads with #N/A. Supply the pad-value argument (e.g. "") if you don’t want errors showing.

Excel 365 only. No WRAPROWS/WRAPCOLS in older versions — reshape with INDEX math or Power Query.

Mind rows vs columns. WRAPROWS’s argument is columns per row; WRAPCOLS’s is rows per column. Easy to mix up.

Practice workbook

📊

Download the free Reshape a List into a Grid (WRAPROWS) practice workbook

WRAPROWS/WRAPCOLS examples (wrap to width, custom pad, flatten+re-wrap) with results shown, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I reshape a list into a grid in Excel?

Use =WRAPROWS(range, N) to fold a single column into rows N values wide, or =WRAPCOLS(range, N) to fill down columns N tall. Requires Excel 365.

How do I avoid #N/A on the last short row?

Add a pad value as the third argument: =WRAPROWS(range, 3, "") fills the gaps with blanks instead of #N/A.

What's the opposite of WRAPROWS?

TOCOL flattens a grid back into a single column. Use TOCOL and WRAPROWS together to reshape data into any layout.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Function references: WRAPROWS · WRAPCOLS