top of page

Lookup & Reference Function - WRAPROWS

Writer's picture: Rachel | The Blue Star AcademyRachel | The Blue Star Academy

Take rows of data and rearrange them into a brand-new array, based on a specified width, or the number of columns.


The video shows the WRAPROWS function in use.


The written calculation is below:


=WRAPROWS(B3:D3,2,"No Data")


In this example, B3:D3 is the array we want to transform into another form.


2 is the number of columns we want to wrap the selected data into.


"No Data" is the text string we want to display if any cells in our new array result in an error message.







8 views0 comments

Recent Posts

See All

Kommentare


bottom of page