Forum Discussion

SridharDasari's avatar
SridharDasari
Copper Contributor
Oct 07, 2020
Solved

Help Need to merge multiple rows into single row

Hi Everyone,   I got a requirement that i need to merge multiple cells in to single cell with sequencing numbers. Need to know how to achieve this. Attached snap & Excel for your reference.   Any...
excel
Excel for web
Macros and VBA
  • Subodh_Tiwari_sktneer's avatar
    Subodh_Tiwari_sktneer
    Oct 07, 2020

    SridharDasari 

     

    If you have access to the TEXTJOIN function, you may try something like this...

     

    =TEXTJOIN(CHAR(10),TRUE,INDEX(A4:A6&". "&B4:B6,))

     

    Select the formula cell and enable the Wrap Text and increase the column width as desired.

     

     

Subodh_Tiwari_sktneer's avatar
Subodh_Tiwari_sktneer
Silver Contributor
Oct 07, 2020

SridharDasari 

 

If you have access to the TEXTJOIN function, you may try something like this...

 

=TEXTJOIN(CHAR(10),TRUE,INDEX(A4:A6&". "&B4:B6,))

 

Select the formula cell and enable the Wrap Text and increase the column width as desired.

 

 

Resources