Forum Discussion
Split one row 16 columnto 4 row 4 columns
Hi, I have a little bit problem for copying and pasting formula. Here an example: In sheet A, for one row data and 16 column in the same row, I want to use equal (=) formula into a 4 rows...
=WRAPROWS(TOCOL(F1:U3),4)
If you work with Office 365 or Excel for the web you can apply this formula. For illustration the result is in the same sheet. Of course you can return the result in another sheet.
=WRAPROWS(TOCOL(F1:U3),4)
If you work with Office 365 or Excel for the web you can apply this formula. For illustration the result is in the same sheet. Of course you can return the result in another sheet.
