Forum Discussion

samiuns's avatar
samiuns
Copper Contributor
Jan 30, 2024

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.

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

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