Quick Navigation

WRAPCOLS Function

Excel 365, Excel 2021+

Summary

The WRAPCOLS function transforms a one-dimensional array or vector into a two-dimensional array by wrapping elements into columns with a specified number of rows per column. Perfect for reshaping long lists into organized table formats.

Syntax

=WRAPCOLS(vector, wrap_count, [pad_with])

Parameters

Parameter	Type	Required	Description
vector	`Array/Reference`	Yes	The input array or cell range containing a single row or column of data
wrap_count	`Number`	Yes	Number of rows each output column should contain
pad_with	`Any`	No	Optional padding value for empty cells in incomplete columns

Using the WRAPCOLS Function

WRAPCOLS excels at restructuring linear data into columnar formats, making it invaluable for creating balanced tables from lists, preparing data for charts, or formatting output for reports. Specify how many rows each column should have, and WRAPCOLS handles the reorganization automatically.

Common WRAPCOLS Examples

Basic Column Wrapping

=WRAPCOLS(A1:A12,3)

Takes 12 values from A1:A12 and creates 4 columns of 3 rows each.

Custom Padding

=WRAPCOLS(A2:G2,3,"-")

Wraps row data into 3-row columns, using "-" instead of #N/A for empty cells.

With Dynamic Arrays

=WRAPCOLS(SEQUENCE(20),5)

Creates 4 perfect columns of 5 rows from numbers 1-20.

Frequently Asked Questions

WRAPCOLS returns #VALUE! error. Input must be a one-dimensional array.

Yes, it works perfectly with SEQUENCE, FILTER, and other dynamic arrays.

Returns original data as a single column.

Common Errors and Solutions

#VALUE!

Cause: Input vector is not a one-dimensional array

Solution: Ensure your range contains only a single row or single column

#NUM!

Cause: wrap_count is less than 1

Solution: Use a positive integer for wrap_count

#N/A in results

Cause: Incomplete final column (normal behavior)

Solution: Use pad_with parameter to replace #N/A with custom value

Notes

Available only in Excel 365 and Excel 2021+
Fills columns vertically (down then across)
Perfect companion to CHOOSEROWS and CHOOSECOLS
Use WRAPROWS for row-major wrapping

Compatibility

Available in: Excel 365, Excel 2021

Not available in: Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007

Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 365, Excel 2021+