Google Sheets | WRAPROWS | Function | Wrap Rows | Example | Spreadsheet | Tutorial | Quick Review

The Google Sheets WRAPROWS function wraps a specified row or column
into one or more rows. This function wraps data at the specified cell.
Extra cells are filled with the #N/A error. Such cells can, however, be filled with a custom text or number.

=====================================
Food & Health Series Using 2D Animation

All the Parts of How to Prevent Diabetes series is based on research findings.

How to Prevent Diabetes Part 1

How to Prevent Diabetes Part 2

How to Prevent Diabetes Part 3

How to Prevent Diabetes Part 4

How to Prevent Diabetes Part 5
=====================================
-------------------------------------
How to Use CHOOSEROWS in Google Sheets?

Extract one or more rows of data using CHOOSEROWS:

-------------------------------------
How to Extract Specific Data Using CHOOSEROWS and MATCH in Google Sheets?

Extract data pertaining to specific strings, using CHOOSEROWS and MATCH functions:

-------------------------------------
How to Use TO_PERCENT in Google Sheets?

Format numbers with percent symbol using the TO_PERCENT function:

-------------------------------------
How to Use FACT and FACTDOUBLE in Google Sheets?

Use FACT and FACTDOUBLE to get the factorial and double factorial of a number:

-------------------------------------
How to Use PERMUT and COMBIN in Google Sheets?

Get the permutations and combinations of n objects:

-------------------------------------
How to Use SUMIFS in Google Sheets?

Use SUMIFS to add numbers based on two or more conditions:

-------------------------------------
How to Use XLOOKUP for Reverse Search in Google Sheets?

XLOOKUP can search for the search key in the regular or reverse order in the lookup range:

-------------------------------------
How to Use XMATCH in Google Sheets?

XMATCH returns the position of the specified search key in a row or column:

-------------------------------------

WRAPROWS Function Formula

=WRAPROWS(range, wrap_count, [pad_with])

Start the formula with an equal-to symbol.

WRAPROWS is the name of the function.

range is a single row or column with data.

wrap_count is the number of cells after which the function wraps the data.

pad_with is optional and is the number or text with which the function fills the extra cells. If omitted, WRAPROWS fills the extra cells with #N/A error.

Examples

Example 1

=WRAPROWS(A2:A7, 2)

The function will transpose the column A2 to A7 into an array of three rows and two columns. In the formula, the optional argument pad_with is omitted. However, no cells will be filled with #N/A error because there will not be any extra cells.

Example 2

=WRAPROWS(A2:A7, 5)

The function will transpose the column A2 to A7 into an array of two
rows and five columns. The five cells of first row and one cell of second row will be filled with data. The remaining four cells of second row will be filled with #N/A error.

Example 3

=WRAPROWS(A2:A7, 5, "---")

The function is almost similar to the above example. The difference is that in this example the pad_with argument with a value of three dashes is used. For this reason, each of the empty cells is filled with three dashes.

Take a look this video tutorial, which gives the steps to use the Google Sheets WRAPROWS function with examples.