Forum Discussion

math_g's avatar
math_g
Copper Contributor
Jun 16, 2020
Solved

How can i sum up a Textchain in Blocks of 4 and pull down the formula?

Hi, I would like to display the text from a column (always 4 rows) in a cell and continue this in the cell below. E.g: Show the text from A1 to A4 in B1, A5 to A8 in B2, A9 to A12 in B3 etc. ...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jun 17, 2020

    math_g 

    That could be in B1

    =CONCAT(INDEX(A:A,(ROW()-1)*4+1):INDEX(A:A,ROW()*4))

    and drag it down 

Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Jun 17, 2020

math_g 

 

And if the TEXTJOIN function is available with the Excel version you are using, you may also try something like this...

 

=TEXTJOIN(,,OFFSET($A$1,(ROW()-1)*4,0,4))