Wraprows function in excel

Описание: Hi,This is excel magic channel.In this channel we share different type of excel tips.In this video how use warprows function in excel.#excel #exceldataanalytics #dataanalysis #exceltips #datamanagement #exceltricks #exceldatamodelingtutorial #exceltutorial #exceldatamodeling #warprows

The WRAPROWS function in Excel converts a row or column of values into a two-dimensional array. Here's how to use the WRAPROWS function:

Select the cell where you want the new table to begin.

In the formula bar, type =WRAPROWS(.

Select the range of cells to wrap.

Add a comma, then enter the number of columns you want in each row.

Close the function with a parenthesis and hit Enter. 

The syntax for the WRAPROWS function is:

=WRAPROWS(vector, wrap_count, [pad_with])

vector: The vector or reference to wrap

wrap_count: The maximum number of values for each row

pad_with: The value with which to pad 

The default value for pad_with is #N/A.

Next video link

   • Видео