This function wraps the provided row or column of cells by columns after a specified number of elements to form a new array.
Sample Usage
WRAPCOLS(A1:E1, 2): A WRAPCOLS function that wraps the range with 2 values per column.
WRAPCOLS(A1:E1, 2, “No value”): A WRAPCOLS function that wraps the range with 2 values per column and fills the extra cells with “No value.”
Syntax
WRAPCOLS(range, wrap_count, [pad_with])
range: The range to wrap.wrap_count: The maximum number of cells for each column. If the value isn’t a whole number, it’s rounded down to the nearest whole number.[pad_with]: The value with which to fill the extra cells in the range. By default, the WRAPCOLS function fills the extra cells with#N/A.
Examples
Wrap simple data with WRAPCOLS
Example data:
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | A | B | C | D | E |
Example: Input this formula in G1: =WRAPCOLS(A1:E1, 2)
Result:
| G | H | I | |
|---|---|---|---|
| 1 | A | C | E |
| 2 | B | D | #N/A |
Wrap data with “No value” as pad with WRAPCOLS
Example data:
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | A | B | C | D | E |
Example: Input this formula in G1: =WRAPCOLS(A1:E1, 2, "No value")
Result:
| G | H | I | |
|---|---|---|---|
| 1 | A | C | E |
| 2 | B | D | No value |
Related functions
- WRAPROWS: This function wraps the provided row or column of cells by rows after a specified number of elements to form a new array.