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.<br /><br />This video shows how WRAPCOLS and WRAPROWS functions are used in Excel.<br /><br />Raw data in one column (vertical table)<br />=WRAPROWS(G1:G90,5)<br /><br />Raw data in one row (vertical table)<br />=WRAPROWS(G1:CR1,5)<br /><br />(LONG) Flipping from one rows to one column data<br />=WRAPROWS(G1:CR1,1)<br /><br />Raw data in one column (horizontal table)<br />=WRAPCOLS(B7:B96,5)<br /><br />Raw data in one row (horizontal table)<br />=WRAPCOLS(B8:CM8,5)<br /><br />Handling Errors with WRAPROWS<br />=WRAPROWS(A1:L1,5)<br />=WRAPROWS(A1:L1,5,"")<br />=WRAPROWS(A1:L1,5,"NA")<br /><br />WRAPROWS function in Excel 365,WRAPCOLS function in Excel 365,Excel WRAPROWS Function, Excel WRAPCOLS Function,WRAPCOLS and WRAPROWS Excel,Wraprows,Wrapcols,Excel functions,
