Once you merge data in Excel, the join will fill columns downward and to the right from the cell you select, so it's usually best to select the uppermost left cell on your worksheet.

Excel's Merge option is useful for merging any group of cells, columns or rows that are adjacent to each other. When using Merge, however, all data except that in the upper-left cell will be deleted.

This 3-day hands-on workshop will show you how to use Microsoft® Excel for making sense of data. You will enhance your data analysis skills and learn how to interpret Excel output.