Skip to content

The WRAPROWS Function in Excel 365

The WRAPROWS function is one of the newest functions recently added to Microsoft Excel.

This function takes a one-dimensional range and transforms the data into a two-dimensional array.

In other words, you can take the data in a single column and split it up across multiple columns. Take a look at this example.

Here, you have the first name, last name, and phone number of each person listed in a single column.

You can use the WRAPROWS function to put the first names in one column, the last names in the next column, and the phone number in a third column.

Keep reading to learn how it works.

How to Use the WRAPROWS Function

The WRAPROWS function accepts three arguments.

=WRAPROWS(Vector, Wrap_count, Pad_with)
  • Vector – A one-dimensional range of cells (Required)
  • Wrap_count – How many columns do you want to split your data into (Required)
  • Pad_with – The value to fill in the gaps at the end of the list (Optional)

To use the WRAPROWS function, you must first select the range of data for the first argument.

You then specify how many columns you want to split the data into.

The WRAPROWS function then does its thing to transform the data from a one-dimensional range to a two-dimensional layout.

The Pad_with Argument

What happens if you use the WRAPROWS function on a dataset that doesn’t have enough values to fill in the last few spaces?

The function will fill these cells with the #N/A error value.

To avoid this, you can use the Pad_with argument to fill these cells with a value of your choice instead.

See It In Action

To see the WRAPROWS function in action, check out this video!

This Post Has 2 Comments

  1. I didn’t even know about this capability! It’s so cool that Excel can do this. The video is such a great visual too!

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top