WRAPCOLS function

The WRAPCOLS function in Excel is used to wrap the values from a single row or column into multiple columns, creating a rectangular array from a list of values. Essentially, it arranges a list into a specified number of columns, wrapping the data horizontally.

Syntax

=WRAPCOLS(vector, wrap_count, [pad_with])

Parameters

• vector: The array or range of values you want to wrap into columns.
• wrap_count: The number of values per column.
• [pad_with] (optional): A value to fill in any missing cells if the total number of items in vector isn’t evenly divisible by wrap_count. By default, this is blank.

How It Works

• The function takes a list of values (either from a single row or column) and wraps them into multiple columns based on the wrap_count specified.
• If the total number of values is not evenly divisible by wrap_count, the optional pad_with argument will fill in any remaining cells.

Examples

Example 1: Wrapping a List into 3 Columns

Suppose you have the following list of values in range A1:A6:

• 1, 2, 3, 4, 5, 6

To wrap these values into 3 columns, use:

=WRAPCOLS(A1:A6, 3)

The output will look like this:

1    4
2    5
3    6

Each column contains 3 values.

Example 2: Wrapping with Padding

Suppose you have the same list of values but fewer values, for example:

• 1, 2, 3, 4

Now, to wrap these values into 3 columns and fill the missing cell with the word “None”, use:

=WRAPCOLS(A1:A4, 3, "None")

The result will be:

1    4
2    None
3    None

Since the list has fewer values than the specified number of columns, the remaining cells are padded with “None.”

Key Points to Remember

• WRAPCOLS is useful when you need to structure data from a single column or row into a rectangular format.
• The wrap_count specifies the number of values per column, essentially controlling how the data is arranged.
• The pad_with argument helps to handle cases where there are not enough values to fill out the last row evenly.

Use Case Scenarios

• Rearranging Data: When you have a long list of values and want to rearrange them into a table-like structure with multiple columns.
• Formatting for Display: Wrapping data into a specified number of columns can make it easier to view or present in a specific format.

The WRAPCOLS function allows you to reorganize data into a structured format, making it easier to work with or analyze.