WRAPCOLS

WRAPCOLS takes a one-dimensional array and wraps it into a two-dimensional table where each column has a specified number of values. It is the column-oriented counterpart to WRAPROWS. If the array does not divide evenly, the last column is padded with a specified value or #N/A. Available in Excel 365 and Google Sheets.

Excel

=WRAPCOLS(A2:A7,3)

Google Sheets

=WRAPCOLS(A2:A7,3)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

How it works

1A2:A7 is the flat 1D source array with 6 values.
23 specifies how many values should appear in each column of the output.
3The result is a 3-row by 2-column table with values filling column by column.

Need a version for your data?

Try: “Arrange a list of 6 items into a table with 3 rows per column”

VLOOKUP XLOOKUP INDEX / MATCH

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

WRAPCOLS

Try it with your data

How it works

Related