Two new functions in Excel that can wrap your data are WRAPROWS and WRAPCOLS. They are basically the opposite of VSTACK and HSTACK. You can read about those here.
WRAPROWS – wrap your data into a set number of columns.
WRAPROWS will take a row or column of cells and spread them over the specified number of columns. It is a bit confusing that it is called WRAPROWS but you specify the number of columns, but it does make sense. You specify how many columns you want and it creates as many rows as required by your data.
In the example above, we have specified, that we want our data in two columns, so this has then made three rows. I guess this can come in handy when you have messy data, that has maybe come from a different system and needs sorting out before you can analyse it.
=WRAPROWS(vector, wrap_count, [pad_with])
The first input required is a vector. This is just a fancy name for a line of data, either in a row or a column. Note that you can’t give the function data that is wider than one cell.
Wrap_count is how many columns you want your data split over.
pad_width is optional (note the square brackets). This is for if your data doesn’t “fill up” all of the last row. If you don’t put anything here, Excel will fill in the gap with a #N/A.
A more useful example shown below.
WRAPCOLS
WRAPCOLS works in the same way, except you specify the number of rows you want, and your data is put into columns.
It has the exact same inputs as WRAPROWS.
So, next time you need to wrap your data into rows or columns you can use the new wrap functions.