Merge Across merges cells in the rows you selected and keeps the left value of each row. Merge Cells merges ... with ...
This article explains how to combine two columns of data in Microsoft Excel into a single column without losing that data.