Excel WRAPROWS function

Summary

The Excel WRAPROWS function is used to convert a one-dimensional array into a two-dimensional array by wrapping values into separate rows. This function is handy for reformatting linear data into a more structured row-based format, ideal for specific analyses or presentation needs.
Syntax
				
					=WRAPROWS(vector, wrap_count, [pad_with])
				
			
  • vector: The one-dimensional array or range to wrap
  • wrap_count: The maximum number of values in each row. When this count is reached, WRAPROWS starts a new row
  • [pad_with]: [Optional] Value to use for filling any unfilled places in the final row
Return value
A two-dimensional array with values wrapped by row.

How to use

Use WRAPROWS by specifying the vector (one-dimensional array or range) and the wrap_count, which determines the number of values per row. Optionally, specify pad_with to fill any unfilled spots in the final row.

Examples

Simple WRAPROWS
Wrapping an Array into Rows: To convert a horizontal range into rows with a specific number of columns:
				
					=WRAPROWS(A1:J1, 4)
				
			
This formula wraps the one-dimensional range A1:J1 into rows, each containing up to 4 values.
WRAPROWS with Different Wrap Counts
Varying Column Lengths in Wrapped Data: Adjusting the number of columns in each row:
				
					=WRAPROWS(A1:J1, 3)
				
			
This formula converts the range A1:J1 into rows with up to 3 values each.
WRAPROWS with Padding
Using Padding to Fill Empty Spaces: To fill empty spaces with a specific value:
				
					=WRAPROWS(A1:J1, 4, "Empty")
				
			
This wraps the range A1:J1 into rows of up to 4 columns each, using “Empty” to fill any unfilled spots in the last row.
WRAPROWS for Vertical Data
Wrapping a Vertical Range into Rows: Converting a vertical range into a structured row format:
				
					=WRAPROWS(A1:A10, 2)
				
			
This formula takes the vertical range A1:A10 and wraps it into rows, each with up to 2 columns.
Advanced WRAPROWS
Complex Reorganization of Data with WRAPROWS: To reorganize data into rows with custom padding:
				
					=WRAPROWS(A1:A12, 5, "N/A")
				
			
Converts the vertical range A1:A12 into rows with up to 5 columns each, using “N/A” to fill any gaps in the final row.

Additional Notes

  • WRAPROWS is a valuable tool for transforming linear data sets into a structured row format.
  • The function automatically starts a new row after reaching the specified wrap_count.
  • WRAPROWS will return a #VALUE! error if the provided vector is not a one-dimensional array or range.

Related Functions

Excel TOROW function

The Excel TOROW function transforms an array into a single row, with flexibility in scanning and options to omit blanks and errors.

Excel TOCOL function

The Excel TOCOL function reorganizes an array into a single column, with options to skip blanks and errors for cleaner data analysis.

Excel WRAPCOLS function

The Excel WRAPCOLS function restructures a linear array into a two-dimensional format by wrapping values into columns, enhancing data presentation.

Content Navigation