After you paste it into the worksheet, press Ctrl+T to convert it into a table, and then rename the table Orange. After you paste it into the worksheet, press Ctrl+T to convert it into a table, and then rename the Excel table Blue. Here's the data for the Blue table, which you can copy into a blank worksheet. If we were to simply copy-and-paste the data from the Orange table, the Sales ID and Region values for the second line item of order 20050 would be off by one row, which would change the values in the new columns in the Blue table. Order ID values repeat in the Blue table, but Order ID values in the Orange table are unique. We want to merge the Sales ID and Region columns with the Blue table, based on matching values in the Order ID columns of the Orange table. So, Order ID 20050 has two items, Order ID 20051 has one item, Order ID 20052 has three items, and so on. In the example shown below, you'll see two tables that previously had other names to new names: 'Blue' and 'Orange.' In the Blue table, each row is a line item for an order. Merge two tables using the VLOOKUP function By using VLOOKUP, you can avoid some of the alignment problems. Merging rows is actually quite simple, but merging columns can be tricky if the rows of one table don't correspond with the rows in the other table. In this case also, the table will increase to accommodate the new columns. If the rows in both tables match up, you can merge the columns of one table with another-by pasting them in the first empty cells to the right of the table. The table will increase in size to include the new rows. The data from cells C1 to C7000 will get pasted in cells A1 to A7000.You can merge (combine) rows from one table into another simply by pasting the data in the first empty cells below the target table. Select cells C1 and C2 and drag down the formula, till cell C7000.

In cell C1, enter the formula =A1&' '&A2. In case of numbers or other type of data, then you need to take adequate precautions. The joining (merging) of data shall depend on the type of data.

One way to do this is by using a temporary helper column. In case, data is present in cells A1, A2, A3, A4., then you may need to merge the data before you perform the operation of merging of cells.

Merge duplicate rows in excel 2007