What is the syntax for WRAPCOLS in Excel?

The syntax for WRAPCOLS is: =WRAPCOLS(vector, wrap_count, [pad_with])

What is WRAPCOLS in Excel?

WRAPCOLS converts a single row or column into a 2D array by filling columns first. For 12 items with wrap_count=4, you get 4 rows × 3 columns, filled top-to-bottom then left-to-right. Useful for creating columnar layouts.

When should I use WRAPCOLS vs WRAPROWS?

Use WRAPCOLS when you want data to flow down columns (like newspaper columns). Use WRAPROWS when you want data to flow across rows (like reading a book). WRAPCOLS is ideal for creating multi-column lists.

How do I create a 3-column list from a single column?

Use =WRAPCOLS(A:A, CEILING(COUNTA(A:A)/3, 1)) to automatically calculate rows needed for 3 columns. Or simply =WRAPCOLS(A1:A30, 10) for 30 items in 3 columns of 10 rows each.

Lookup & Reference

WRAPCOLS Function in Excel

Wraps a row or column of values into a 2D array after a specified number of elements by column.

Syntax

=WRAPCOLS(vector, wrap_count, [pad_with])

Arguments

vector (required): Row or column to wrap
wrap_count (required): Number of values per column
pad_with (optional): Value for padding (default #N/A)

Examples

=WRAPCOLS(A1:A12, 4) - Wrap 12 items into 4 rows of 3 columns - Result: 4x3 array

When to use WRAPCOLS

Use WRAPCOLS when you need to retrieve values from a table or range based on a key.
Confirm data types match (text vs number) and trim spaces before lookups.
Pair with [IFERROR](/functions/iferror/) or [IFNA](/functions/ifna/) for cleaner reports.
See the [lookup functions guide](/guides/excel-lookup-functions-guide/) for VLOOKUP, XLOOKUP, and INDEX MATCH paths.

Common WRAPCOLS mistakes

#N/A often means the key is missing or exact match is wrong — see [#N/A error](/errors/na/).
Lock table references with $ when copying formulas down a column.
Compare legacy vs modern lookups in [XLOOKUP vs VLOOKUP](/compare/xlookup-vs-vlookup/).

Common errors

Requires Excel 365

Use cases

Reshape data
Create tables
Data transformation

Frequently asked questions

What is WRAPCOLS in Excel? WRAPCOLS converts a single row or column into a 2D array by filling columns first. For 12 items with wrap_count=4, you get 4 rows × 3 columns, filled top-to-bottom then left-to-right. Useful for creating columnar layouts.
When should I use WRAPCOLS vs WRAPROWS? Use WRAPCOLS when you want data to flow down columns (like newspaper columns). Use WRAPROWS when you want data to flow across rows (like reading a book). WRAPCOLS is ideal for creating multi-column lists.
How do I create a 3-column list from a single column? Use =WRAPCOLS(A:A, CEILING(COUNTA(A:A)/3, 1)) to automatically calculate rows needed for 3 columns. Or simply =WRAPCOLS(A1:A30, 10) for 30 items in 3 columns of 10 rows each.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.