How to Merge Columns From Two Tables

1. Open the Excel file that contains the two tables with the data you want to merge.
2. Select the cell where you want the merged column to start and type in a header for the column. Select the cell directly beneath the header. If you want the merged call to be part of one of the tables, right-click on the top of the column where it lists the column letter, directly to the right of where you want the new column to go. Choose 'Insert.'
3. Enter in the following: =CONCATENATE(XX,' ',YY) Make 'XX' equal to the first cell that you want to merge, and make 'YY' equal to the cell in the second column you want to merge with the first. Both 'XX' and 'YY' need to follow Excel's standard naming rules, which list the column letter followed by the row number, like 'A1' or 'C23.' Press 'Enter' when you are done typing in the formula. The two cells will merge in your new column.
4. Click on the cell that you just entered the formula into and move your mouse over the lower-left corner of the cell. When the mouse cursor turns into a plus sign, click and hold the mouse button. Drag the mouse down until you have reached the last row of the column and release the mouse button. The entire column will fill with data merged from the two original columns.