Forum Discussion

Sreepathi's avatar
Sreepathi
Copper Contributor
Jun 11, 2020

Help with merging multiple row into same single row cell

Hi Excels,

I am trying to merge distributed different row values in to single cell, Please see the image for understanding. There are 1000 files need to address. Please suggest me formula oriented solution. I tried Waiting for Views.

Thanks & Regards 

Sreepathi k

excel
Macros and VBA

2 Replies

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jun 11, 2020

    Sreepathi You can not merge cells and retain the content of each cell.

    But you can create what you want by TEXTJOIN (newer Excel versions) or CONCAT (all Excel versions)

    =TEXTJOIN(CHAR(10),,A2:A6)

or

=CONCAT(A2&CHAR(10)&A3&CHAR(10)&A4&CHAR(10)&A5&CHAR(10)&A6)

    ..... and format the cell with either of these formulae (in this case B1) to "Wrap Text"

     

Resources