Lookup & Reference
Reshape a Single Column Into Fixed-Width Rows or Columns (WRAPROWS & WRAPCOLS Formula)
Convert a flat 1D vertical list into a row-major (WRAPROWS) or column-major (WRAPCOLS) 2D table with custom padding for incomplete final blocks using INDEX and COUNTA.
Row-major (WRAPROWS) vs. column-major (WRAPCOLS) 2D indexing
When a CRM export or barcode scan lands in a single vertical column A2:A11, reshaping it into a grid of width W (WRAPROWS) maps 1-based output row r and column c to linear source index idx = (r - 1) * W + c. Reshaping column-first with height H (WRAPCOLS) maps (r, c) to idx = (c - 1) * H + r.
Guarding idx > COUNTA($A$2:$A$11) with a configurable pad token (such as "—" instead of #N/A) produces clean print badges, seating charts, and catalog cards. In Arte Sheets, teams co-editing shared layout sheets see live collaborator cursors and can also ask the AI Assistant to insert or rename output sheets and columns before populating reshaped grids.
| Output Row (r) | Col 1 (c=1) | Col 2 (c=2) | Col 3 (c=3) | Col 4 (c=4) |
|---|---|---|---|---|
| Row 1 | SKU-01 (idx 1) | SKU-02 (idx 2) | SKU-03 (idx 3) | SKU-04 (idx 4) |
| Row 2 | SKU-05 (idx 5) | SKU-06 (idx 6) | SKU-07 (idx 7) | SKU-08 (idx 8) |
| Row 3 | SKU-09 (idx 9) | SKU-10 (idx 10) | — (idx 11 > 10) | — (idx 12 > 10) |
Row-Major WRAPROWS Cell Formula With Custom Padding
Retrieves the item for grid row D4 and grid column D5 across wrap width D2, returning pad string D3 when the index exceeds the source item count.
=LET(idx, (D4 - 1) * $D$2 + D5, IF(idx > COUNTA($A$2:$A$11), $D$3, INDEX($A$2:$A$11, idx)))Column-Major WRAPCOLS Cell Formula & Required Grid Row Count
Switches the index mapping to (col - 1) * wrap_height + row for newspaper-style vertical columns, while ROUNDUP(COUNTA(A2:A11) / D2, 0) calculates total rows needed.
=ROUNDUP(COUNTA(A2:A11) / D2, 0)Try the example
Use the original values or change them to test your understanding.