Excel functions / Dynamic arrays

WRAPCOLS function

Wraps a row or column of values into columns of a set length.

Syntax

=WRAPCOLS(vector, wrap_count, [pad_with])

Arguments

When to use it

WRAPCOLS turns a single row or column into a grid, filling a column at a time with a set number of values, as a newspaper fills columns.

Examples

  1. Six items, two to a column

    ABCDE
    1ItemPenFolderGlue
    2PenStaplerTapeRuler
    3Stapler
    4Folder
    5Tape
    6Glue
    7Ruler

    In C1: =WRAPCOLS(A2:A7, 2) → Pen, Folder, Glue; Stapler, Tape, Ruler

    Try this example

Common mistakes

WRAPCOLS in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try WRAPCOLS in the playground

Related functions