Thankfully, Excel makes merging and splitting cells ... cells in the rows you selected and keeps the left value of each row.

This article explains how to combine two columns of data in Microsoft Excel into a single column without losing that data.

These shortcuts are found in both the "Data" and "Home" tabs. Excel automatically tries to alphabetize vertically by column, but you can easily adjust this setting to sort horizontally by row.