WRAPROWS function in Excel 365 - Excel Tips and Tricks

Описание: The WRAPCOLS and WRAPROWS Functions in Excel 365 "wraps" the provided row or column of values by rows after a specified number of elements to form a new array. In another words, the WRAPROWS and WRAPCOLS function in Excel converts a row or column of values into a two-dimensional array based on the number of values per row that you specify.

This video shows how WRAPROWS functions are used in Excel.

Raw Data in one column (vertical table)
=WRAPROWS(G1:G90,5)

Raw Data in one row (vertical table)
=WRAPROWS(G1:CR1,5)

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips