Excel WRAPCOLS function
The WRAPCOLS function converts a single row or column into multiple columns (a 2-demensional array) by specifying the number of values in each column.
Note: This function is only available in Excel for Microsoft 365 on the Insider channel.
Syntax
=WRAPCOLS(vector, wrap_count, [pad_with])
Arguments
Remarks
Return value
It returns an array wrapped by columns.
Example
As shown in the screenshot below, to convert the one-dimensional array in the range B6:B15 into multiple columns, and each column contains at most 2 values, you can apply the WRAPCOLS function to get it done.
Select a blank cell, such as D6 in this case, enter the following formula and press the Enter key to get the columns.
=WRAPCOLS(A6:A15,2)
Notes: If you specify at most 3 values for each column, you will find that there are insufficient values to fill the cells in the last column, and #N/A is used for the missing values.
To replace the #N/A with a specified value, for example a word “NULL”, you need to specify the argument “pad_with” as “NULL”. See the formula below.
=WRAPCOLS(A6:A15,2,"NULL")
Related Functions
Excel WRAPROWS function
The WRAPROWS function converts a single row or column into multiple rows (a 2-demensional array) by specifying the number of values in each row.
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.
