This blog post will provide insights on how you can merge and combine column values in Microsoft Excel 2016.
How to merge and combine column data in Microsoft Excel 2016 ?
You can use to merge and combine column data without losing data in Excel using the & operator to concatenate data.
Assume that you have the column A and B and you wish to merge and combine the column data and display it in Column C.
You can simply add the formula as shown to the cells of Column C
=A1&” “&B1
This will merge and combine the column data and display it in with spaces in between.