Combining rows

%3CLINGO-SUB%20id%3D%22lingo-sub-1361170%22%20slang%3D%22en-US%22%3ECombining%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1361170%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20way%20to%20combine%20text%20from%20multiple%20rows%20into%20a%20single%20row%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1361170%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1361634%22%20slang%3D%22en-US%22%3ERe%3A%20Combining%20rows%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1361634%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F656719%22%20target%3D%22_blank%22%3E%40CHenry1425%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere's%20a%20few%20options.%26nbsp%3B%20You%20could%20use%20the%20TEXTJOIN%20function%2C%20or%20the%20CONCAT%20function.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Is there a way to combine text from multiple rows into a single row?

2 Replies
Highlighted

@CHenry1425 

There's a few options.  You could use the TEXTJOIN function, or the CONCAT function.

Highlighted

@CHenry1425 

It depends on what do you mean - texts from different rows in same column into one cell of the same column; texts from different rows/columns into one row but same columns; or what?