Excel like a finance pro.
← The libraryPractice · 2 questions →
Dynamic array function
WRAPCOLS
Wraps a single row or column into columns of a given height.
Rarely usedDifficulty 1450 · AdvancedUsage rank #115 of 520
When to use it
Wraps a single row or column into columns of a given height.
The shape of it
- Syntax
=WRAPCOLS(vector, wrap_count, [pad_with])
Worked examples
Columns of two
=WRAPCOLS(SEQUENCE(6),2) → {1,3,5;2,4,6}
Fills down two, then starts a new column.
With padding
=WRAPCOLS(A1:A7,3,"") → 3 rows, last cell blank
Padded.
Months in columns
=WRAPCOLS(A1:A24,12) → two columns of twelve
Two years of months side by side.
Worth knowing
- Print a long list in newspaper columns.
- Pad to avoid #N/A.
- WRAPROWS for the other direction.
Where it goes wrong
- #VALUE! when the input is not a single row or column.
- Requires Microsoft 365.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.