Home

Combine data from multiple rows into a single row separated by a comma and space

%3CLINGO-SUB%20id%3D%22lingo-sub-288829%22%20slang%3D%22en-US%22%3ECombine%20data%20from%20multiple%20rows%20into%20a%20single%20row%20separated%20by%20a%20comma%20and%20space%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-288829%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20lot%20of%20data%20I'll%20need%20to%20move%20from%20one%20column%20into%20one%20single%20cell%20separated%20by%20comma%20space.%20The%20data%20is%20letters%20and%20numbers.%20I've%20tried%20the%20TEXTJOIN%20feature%20and%20it's%20not%20working.%20Any%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExample%3A%3CBR%20%2F%3E234AB234%3CBR%20%2F%3E9430D5423K%3CBR%20%2F%3EKENO934DW%3CBR%20%2F%3E9443G74K%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENeeds%20to%20be%3A%20234AB234%2C%209430D5423K%2C%20KENO934DW%2C%209443G74K%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-288829%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-661696%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20data%20from%20multiple%20rows%20into%20a%20single%20row%20separated%20by%20a%20comma%20and%20space%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-661696%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BI%20have%20experienced%20the%20same%20issue%20(TEXTJOIN%20doesn't%20work)%20while%20attempting%20to%20combine%20data%20from%2033%20rows%20into%20a%20single%20row%20separated%20by%20a%20comma.%26nbsp%3B%20Do%20you%20know%20of%20another%20method%20that%20does%20not%20require%20extensive%20data%20entry%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-288960%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20data%20from%20multiple%20rows%20into%20a%20single%20row%20separated%20by%20a%20comma%20and%20space%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-288960%22%20slang%3D%22en-US%22%3E%3CP%3ETEXTJOIN%20doesn't%20work%20since%20you%20don't%20have%20it%20(you%20are%20not%20Office365%20subscriber)%20or%20that's%20something%20else%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-288841%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20data%20from%20multiple%20rows%20into%20a%20single%20row%20separated%20by%20a%20comma%20and%20space%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-288841%22%20slang%3D%22en-US%22%3E%3CP%3ETo%20add%20to%20erol%20sinan's%20formula%2C%20in%20cell%20B2%2C%20enter%20the%20formula%20%3DB1%26amp%3B%22%2C%20%22%26amp%3BA3%2C%20then%20use%20the%20auto%20fill%20handle%20to%20copy%20it%20down.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-288837%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20data%20from%20multiple%20rows%20into%20a%20single%20row%20separated%20by%20a%20comma%20and%20space%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-288837%22%20slang%3D%22en-US%22%3E%3CP%3Eyou%20can%20use%20Concatenate%20function%20or%20%22%26amp%3B%22%20sign%20between%20adresses%20to%20add%20multiple%20text%20together%20for%20example%20if%20you%20have%20%3CSPAN%3E234AB234%20in%20cell%20A1%20and%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E9430D5423K%20in%20cell%20A2%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DA1%20%26amp%3B%22%2C%20%22%20A2%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eformula%20will%20gibe%20%22%3CSPAN%3E234AB234%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3E9430D5423K%22%20as%20result%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-661804%22%20slang%3D%22en-US%22%3ERe%3A%20Combine%20data%20from%20multiple%20rows%20into%20a%20single%20row%20separated%20by%20a%20comma%20and%20space%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-661804%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F352824%22%20target%3D%22_blank%22%3E%40shayalynn%3C%2FA%3E%26nbsp%3B%2C%20several%20ways%20without%20it%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fchandoo.org%2Fwp%2Fcombine-text-values-quick-tip%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fchandoo.org%2Fwp%2Fcombine-text-values-quick-tip%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%3CA%20href%3D%22http%3A%2F%2Fwww.excelcampus.com%2Fkeyboard-shortcuts%2Fconcatenate-range-of-cells%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.excelcampus.com%2Fkeyboard-shortcuts%2Fconcatenate-range-of-cells%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3Eplus%20with%20PivotTable%3C%2FP%3E%3C%2FLINGO-BODY%3E
null null
Occasional Visitor

I have a lot of data I'll need to move from one column into one single cell separated by comma space. The data is letters and numbers. I've tried the TEXTJOIN feature and it's not working. Any ideas?

 

Example:
234AB234
9430D5423K
KENO934DW
9443G74K

 

Needs to be: 234AB234, 9430D5423K, KENO934DW, 9443G74K

 

5 Replies

you can use Concatenate function or "&" sign between adresses to add multiple text together for example if you have 234AB234 in cell A1 and 9430D5423K in cell A2:

 

=A1 &", " A2 

 

formula will gibe "234AB234, 9430D5423K" as result

To add to erol sinan's formula, in cell B2, enter the formula =B1&", "&A3, then use the auto fill handle to copy it down.  

TEXTJOIN doesn't work since you don't have it (you are not Office365 subscriber) or that's something else?

@Sergei Baklan I have experienced the same issue (TEXTJOIN doesn't work) while attempting to combine data from 33 rows into a single row separated by a comma.  Do you know of another method that does not require extensive data entry?

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies