How to concatenate values into distinct comma separated values in excel

Question

Name    Class1  Class2  Class3  Class4
XYZ LLC INC1    INC2    INC1    
ABC Inc INC4    INC1    INC2    INC1
ZZZ InC INC

Result

Name    Combine
XYZ LLC INC1,INC2
ABC Inc INC4,INC1,INC2
ZZZ Inc INC

score 0 · Accepted Answer · answered Apr 18 '19 at 19:31

0

Use a simple TEXTJOIN:

=TEXTJOIN(",",TRUE,B2:E2)

answered Apr 18 '19 at 19:31

Scott Craner

I am using 2016 excel and it has no Textjoin function, do you know any other function? – Mike Apr 18 '19 at 19:58
Nope, you will need vba. See [Here](https://stackoverflow.com/questions/39532189/vlookup-with-multiple-criteria-returning-values-in-one-cell) for a UDF that you can put in a module and then use the Formula above. – Scott Craner Apr 18 '19 at 20:04

1 Answers1