SOLVED

seeking excel method/function to group text in rows

%3CLINGO-SUB%20id%3D%22lingo-sub-2779544%22%20slang%3D%22en-US%22%3Eseeking%20excel%20method%2Ffunction%20to%20group%20text%20in%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2779544%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20have%20a%20report%20that%20I%20would%20need%20to%20group%20the%20data%20from%20multiple%20rows%20into%20one%20cell.%20For%20example%2C%20for%20the%20chart%20below%2C%20I%20would%20like%20all%20of%20this%20information%20in%20one%20line%20like%20this%3A%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22377px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2267.875px%22%3Etest%3C%2FTD%3E%3CTD%20width%3D%2269.8594px%22%3E123%3C%2FTD%3E%3CTD%20width%3D%22238.266px%22%3Eapples%20oranges%20grapes%20bananas%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20width%3D%22285px%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2268.8438px%22%3EFirst%20Name%3C%2FTD%3E%3CTD%20width%3D%2270.8281px%22%3ELast%20Name%3C%2FTD%3E%3CTD%20width%3D%22144.328px%22%3EData%20to%20be%20grouped%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2268.8438px%22%3Etest%3C%2FTD%3E%3CTD%20width%3D%2270.8281px%22%3E123%3C%2FTD%3E%3CTD%20width%3D%22144.328px%22%3Eapples%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2268.8438px%22%3Etest%3C%2FTD%3E%3CTD%20width%3D%2270.8281px%22%3E123%3C%2FTD%3E%3CTD%20width%3D%22144.328px%22%3Eoranges%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2268.8438px%22%3Etest%3C%2FTD%3E%3CTD%20width%3D%2270.8281px%22%3E123%3C%2FTD%3E%3CTD%20width%3D%22144.328px%22%3Egrapes%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2268.8438px%22%3Etest%3C%2FTD%3E%3CTD%20width%3D%2270.8281px%22%3E123%3C%2FTD%3E%3CTD%20width%3D%22144.328px%22%3Ebananas%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20%26amp%3B%20thank%20you!%20VC%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2779544%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2779574%22%20slang%3D%22en-US%22%3ERe%3A%20seeking%20excel%20method%2Ffunction%20to%20group%20text%20in%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2779574%22%20slang%3D%22en-US%22%3E%3DTEXTJOIN(%22%20%22%2CTRUE%2CC2%3AC5)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2779578%22%20slang%3D%22en-US%22%3ERe%3A%20seeking%20excel%20method%2Ffunction%20to%20group%20text%20in%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2779578%22%20slang%3D%22en-US%22%3EI%20worked!%20you%20are%20awesome%3A)%20TY!%20TY!%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2779597%22%20slang%3D%22en-US%22%3ERe%3A%20seeking%20excel%20method%2Ffunction%20to%20group%20text%20in%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2779597%22%20slang%3D%22en-US%22%3EYou're%20welcome.%3CBR%20%2F%3EDont%20forget%20to%20flag%20it%20as%20solved%20and%20hit%20the%20like%20button.%3C%2FLINGO-BODY%3E
New Contributor

Hello,

I have a report that I would need to group the data from multiple rows into one cell. For example, for the chart below, I would like all of this information in one line like this: 

test123apples oranges grapes bananas

 

First NameLast NameData to be grouped
test123apples
test123oranges
test123grapes
test123bananas

 

Please & thank you! VC

5 Replies
best response confirmed by VC_123 (New Contributor)
Solution
=TEXTJOIN(" ",TRUE,C2:C5)
I worked! you are awesome:) TY! TY!
You're welcome.
Dont forget to flag it as solved and hit the like button.
I am sorry to ask, how do I flag it as solved?
Already flagged as solved.