ExcelFlux

WRAPROWS function

Wraps the provided row or column of values by rows after a specified number of elements.

Lookup and reference · Excel 2024+

Where can you use it?

Reporting and operations teams. Use functions in this group to retrieve a field from an item, employee or order list, select the right record, or move values into another report.

Scenario in the workbook

Wrap an input row at a width of two items; the two sample values fit on one row.

A worked example from the workbook

RowABC
6InputSecond inputPosition
710201
830402
950601
Record 1
=INDEX(WRAPROWS($A$7:$B$7,2),1,C7)

Expected result10

See the inputs and instructions for all 3 examples

Syntax

WRAPROWS(vector, wrap_count, [pad_with])

Copyable formulas

English Excel · en-US
=INDEX(WRAPROWS($A$7:$B$7,2),1,C7)
Turkish Excel · tr-TR
=İNDİS(SATIRSAR($A$7:$B$7;2);1;C7)

Worked examples

Wrap an input row at a width of two items; the two sample values fit on one row.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B C
6 Input Second input Position
7 10 20 1
8 30 40 2
9 50 60 1
Case Formula Expected result
Record 1 =INDEX(WRAPROWS($A$7:$B$7,2),1,C7) 10
Record 2 =INDEX(WRAPROWS($A$7:$B$7,2),1,C8) 20
Record 3 =INDEX(WRAPROWS($A$7:$B$7,2),1,C9) 10
Microsoft Excel reference