Administration and Executive AssistantTier 920 minintermediate

WRAPROWS Width

Reshape twelve months of figures into a grid with the right number of months per row.

What you will learn

• Use WRAPROWS to reshape a flat list into a grid of a given width
• Explain how WRAPROWS's wrap count determines where each value lands
• Recognise that a wrong wrap count still produces a full grid, just with every value shifted

Excel skills

WRAPROWS · Array Formulas

The task

Twelve months of unit sales are listed in a single column. Reshape them into a grid 3 months wide, and report row 2, column 1 (month 4's figure) in Summary!B3.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free