Forum Discussion
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 insights are highly appreciated.
Thanks
Sridhar Dasari
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 Replies
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.
You're Welcome SridharDasari!
