Excel2010 How to merge cells with the same content in a table

Excel2010 How to merge cells with the same content in a table

1, such a problem of course can be entered at 1.1 or copy text into the same cell, but the data is not good, if the number of such a workload is very large. So we take the following approach to achieve the goal.

2, first set up a secondary column, named "Results" (the name of God horse does not matter ~) in the C2 cell input formula =if (a2=a3,b2& "," &c3,b2). Fills down to the last row of the table.

3. At this point, it can be found that the first occurrence of the line in each province shows a comma-linked text of all cities in the province. These texts are exactly the result we want!

4, copy the third column, still in the third column "Paste selectively", the third column of the formula into a numerical value.

5, select the data table, this example is the choice of A1~C10. Click "Data" in the toolbar and click "Delete Duplicates", as shown in the following figure.

6, the pop-up window is as follows. Cancel the hook before column B, column C, and click OK. As shown in the following figure.

7, this time the system will prompt you to delete the completion, as shown in the following figure. Click Finish to OK. Do you think it's practical? Come on, give it a try.