How to merge and combine columns without losing data in Excel

If you merge multiple columns of data in Excel (no matter which Excel version you are using), only the left column of data will be kept, and the data of other columns will be deleted, if you apply the "Merge and Center" command from Home tab on the Alignment group. This vedio is talking about how to merge or combine different columns of data into one cell or column in Excel.
You can follow the step-by-step guide via the following hyperlink:
https://www.extendoffice.com/document...