This brief overview of the XLTools Combine Cells Data for Excel shows:
How to join, combine and merge cells without losing data
How to combine rows, columns, or place data into a single cell
How to combine cells contents and set any separator between the values
Download at https://xltools.net/download/
Suitable for Microsoft Excel 2016, 2013, 2010, 2007, and desktop version of Office 365 (32-bit and 64-bit).