SOLVED

Help Need to merge multiple rows into single row

%3CLINGO-SUB%20id%3D%22lingo-sub-1752373%22%20slang%3D%22en-US%22%3EHelp%20Need%20to%20merge%20multiple%20rows%20into%20single%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1752373%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20got%20a%20requirement%20that%20i%20need%20to%20merge%20multiple%20cells%20in%20to%20single%20cell%20with%20sequencing%20numbers.%20Need%20to%20know%20how%20to%20achieve%20this.%20Attached%20snap%20%26amp%3B%20Excel%20for%20your%20reference.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20insights%20are%20highly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ESridhar%20Dasari%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Capture.JPG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F224731i54BE613AA9DEE764%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Capture.JPG%22%20alt%3D%22Capture.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1752373%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1752452%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Need%20to%20merge%20multiple%20rows%20into%20single%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1752452%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F791266%22%20target%3D%22_blank%22%3E%40SridharDasari%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20have%20access%20to%20the%20TEXTJOIN%20function%2C%20you%20may%20try%20something%20like%20this...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DTEXTJOIN(CHAR(10)%2CTRUE%2CINDEX(A4%3AA6%26amp%3B%22.%20%22%26amp%3BB4%3AB6%2C))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelect%20the%20formula%20cell%20and%20enable%20the%20Wrap%20Text%20and%20increase%20the%20column%20width%20as%20desired.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1752508%22%20slang%3D%22en-US%22%3ERe%3A%20Help%20Need%20to%20merge%20multiple%20rows%20into%20single%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1752508%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394231%22%20target%3D%22_blank%22%3E%40Subodh_Tiwari_sktneer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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

 

Capture.JPG

 

3 Replies
Best Response confirmed by SridharDasari (Occasional Contributor)
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.