How to Use WRAPCOLS and WRAPROWS Functions in Excel
The WRAPCOLS and WRAPROWS Functions let you reshape a single column of data into a multi-column or multi-row layout. They are useful for transforming long lists into structured grids — and they update automatically when your source data changes.
YouTube Video
WRAPROWS & WRAPCOLS in Excel - Chris Menard Video
WRAPCOLS: Split a Column into Multiple Columns
The WRAPCOLS function takes a single column of values and wraps them into a specified number of rows, filling across columns. The syntax is:
=WRAPCOLS(vector, wrap_count, [pad_with])- vector — the range or array to wrap
- wrap_count — the number of values per column (how many rows before wrapping to the next column)
- pad_with (optional) — value to use when the last column doesn't have enough items to fill
For example, if you have 12 employee names in a single column and use =WRAPCOLS(A2:A13, 4), you get a 4-row by 3-column grid.
WRAPROWS: Split a Column into Multiple Rows
The WRAPROWS function works similarly but fills across rows first. The syntax is:
=WRAPROWS(vector, wrap_count, [pad_with])Using =WRAPROWS(A2:A13, 3) takes the same 12 names and arranges them into rows of 3 — resulting in a 4-row by 3-column grid, but filled horizontally rather than vertically.
Dynamic Updates with Excel Tables
When your source data is in an Excel Table, both functions update automatically as you add or remove items. Add a new employee name to the table and the wrapped output expands to include it — no manual adjustment needed.
Practical Example: Random Group Assignment
Combine WRAPCOLS or WRAPROWS with RANDBETWEEN to randomly assign people to groups. Generate random numbers alongside names, sort by the random values, and wrap the sorted list into groups of your desired size. This is useful for classroom activities, team assignments, or workshop groupings.
Related Guides
Want to learn more? Visit courses.chrismenardtraining.com for online training courses.
