Jan 30 2024 01:28 AM
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.
Jan 30 2024 02:14 AM
Solution=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.
Jan 30 2024 06:58 PM
Jan 30 2024 02:14 AM
Solution=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.