# WRAPCOLS

## Content

This function wraps the provided row or column of values by columns after a specified number of elements to form a new array.

>type=note
> **Note**: WRAPCOLS is a dynamic array formula, and you need to enable the dynamic array feature in the Workbook.

## Syntax

`WRAPCOLS(vector, wrap_count, [pad_with])`

## Arguments

The function has the following arguments:

| Argument | Description |
| -------- | ----------- |
| *vector* | [Required] The vector or reference to wrap. |
| *wrap\_count* | [Required] The maximum number of values for each column. |
| *pad\_with* | [Optional] The value with which to pad. The default is #N/A. |

## Remarks

The elements of the vector are placed into a 2-dimensional array by column. Each column has wrap\_count elements. The column is padded with pad\_with if there are insufficient elements to fill it. If wrap\_count is greater or equal to the number of elements in vector, then the vector is simply returned as the result of the function.

## Examples

![image](https://cdn.mescius.io/document-site-files/images/ae7843c3-c78e-4c99-ad9b-232e3606de10/image.061b72.png?width=500)