There's a really good VBA concatall function here:

https://www.excelforum.com/showthread.php?p=3096647