dding the names from the 3 columns (A+B+C-AB-AC-BC-ABC).
this is not clear
I have given a solution for similar problem for two columns in t\
see whether you can modify that solution to suit you
in an empty columns(row 1 is having colulmn heading ) e.g.F2
type the formula A2&B2&C2
and copy F2 down
Modify the macro there (changing E to F) and run the macro
first do this solution (concatenating and running the macro) on a sample data.