Combine Many Cells Into One Cell

[Legacy 436357]

Hello,

I have test equipment numbers in separate columns. How can I combine them into one column with the numbers separated by commas and one space after each comma?

Note some columns don't have numbers.

Thank you

Excel Workbook
	E	F	G	H	I	J
112	663
113	1372	1240	355	105
114	663	1422	1408
115	1180	1417
116	922	1365	1424
117	663
118	1379	1380	1415	1373	883	884
119	663	801
120
121	1217	1218	1240	1365
122	663	801	1415
123
124	556	1018	1418
125	556	1018	1418
126	556	1418
127	1202	697
128	642	144	9	1415
Sheet1

 

[Legacy 436357]

Fluff,

The code works perfectly thank you so much!

 

[Fluff]

You're welcome & thanks for the feedback

 

[jondavis1987]

I know Fluff already solved it but if you enter this it would work as well

=IF(AND(E112>0,SUM(F112:K112)>0),E112&", ",IF(E112>0,E112,""))&IF(AND(F112>0,SUM(G112:K112)>0),F112&", ",IF(F112>0,F112,""))&IF(AND(G112>0,SUM(H112:K112)>0),G112&", ",IF(G112>0,G112,""))&IF(AND(H112>0,SUM(I112:K112)>0),H112&", ",IF(H112>0,H112,""))&IF(AND(I112>0,SUM(J112:K112)>0),I112&", ",IF(I112>0,I112,""))&IF(AND(J112>0,K112>0),J112&", ",IF(J112>0,J112,""))&IF(K112>0,K112,"")

 

[Legacy 436357]

Thank jondavis1987 as well for your formula.