Syntax
WRAPCOLS(vector, wrap_count, [pad_with])
| Parameter | Description |
|---|---|
| vector | Parameter of the WRAPCOLS function. |
| wrap_count | Parameter of the WRAPCOLS function. |
| [pad_with] | (Optional.) Parameter of the WRAPCOLS function. |
Examples
Monthly data into quarterly columns
Formula
=WRAPCOLS(A1:A12, 3)
Wraps 12 monthly values into a 3-row by 4-column array. Each column represents a quarter (Jan-Mar, Apr-Jun, Jul-Sep, Oct-Dec).
Contact list in 3 columns
Formula
=WRAPCOLS(A1:A30, 10)
Arranges 30 names into 3 columns of 10 rows each, like a phonebook layout.
Pad incomplete columns
Formula
=WRAPCOLS(A1:A10, 4, "-")
Wraps 10 values into columns of 4. The last column has 2 values and 2 cells showing '-' as the pad character.
Common Errors
#VALUE!
The wrap_count is zero or negative, or the input is not a single row or column.
#SPILL!
The output area contains non-empty cells.
Tips
Pad value prevents #N/A
If the vector length isn't evenly divisible by wrap_count, extra cells are padded with #N/A by default. Set pad_with to 0 or "" for cleaner output.
WRAPCOLS vs WRAPROWS
WRAPCOLS fills top-to-bottom within each column, then moves right. WRAPROWS fills left-to-right within each row, then moves down. Choose based on your reading order.
Reshape for reports
Turn a single-column data export into a multi-column report layout instantly. Great for print layouts that need to fill the page width.
Try WRAPCOLS in Viztab
Import your data and use WRAPCOLS with 370+ other formulas. No signup required.
Open Viztab