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 with 4 columns in the sheet B.
From picture above, I have row number 2, and column F through U (sheet A)
In first row of sheet B, I want to use that data but only column F to I. The next row, I want to use data from column J to M, then N to Q and R to U.
So now I have one 4 rows of data and column which is a split for one row from sheet A.
How can I copy and paste 4 rows, with a formula which use a same row number in the formula, and only increasing by 1 after 4 rows?
Thanks.
=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.
- OliverScheurichGold Contributor
=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.
- samiunsCopper Contributor