Скачать или смотреть WRAPCOLS 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 WRAPCOLS and 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)

(LONG) Flipping from one rows to one column data
=WRAPROWS(G1:CR1,1)

Raw data in one column (horizontal table)
=WRAPCOLS(B7:B96,5)

Raw data in one row (horizontal table)
=WRAPCOLS(B8:CM8,5)

Handling Errors with WRAPROWS
=WRAPROWS(A1:L1,5)
=WRAPROWS(A1:L1,5,"")
=WRAPROWS(A1:L1,5,"NA")

#excel #tips #shorts #fyp