Help Need to merge multiple rows into single row

[SridharDasari]

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 insights are highly appreciated.

Thanks

Sridhar Dasari

[#2 · Accepted solution]

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

[#3]

Thanks @Subodh_Tiwari_sktneer 

[#4]

You're Welcome @SridharDasari!