SOLVED

Split one row 16 columnto 4 row 4 columns

Copper Contributor

Hi, 

 

I have a little bit problem for copying and pasting formula. Here an example:

Screenshot 2024-01-30 at 17.36.56.png

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.

2 Replies
best response confirmed by samiuns (Copper Contributor)
Solution

@samiuns 

=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.

split rows.png

Thanks @OliverScheurich, the formula works great. You're a lifesaver. 🙏🏼🙏🏼🙏🏼
1 best response

Accepted Solutions
best response confirmed by samiuns (Copper Contributor)
Solution

@samiuns 

=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.

split rows.png

View solution in original post