How to merge similar items in Excel

In daily work, we often need to process a large amount of data. One of the important operations is to merge similar items. In response to this problem, PHP editor Baicao will introduce to you a simple, easy-to-understand and easy-to-operate method of merging similar items in Excel to help you easily solve data processing problems. Below are detailed steps and examples for your reference.

Take the row of cells below as an example to merge names.

Insert an auxiliary serial number on the right side of the table.

Click [Pivot Table] in the [Insert] tab above.

After creation, drag both the auxiliary column and the name column into the [Row Label] below.

Click on the PivotTable option in the upper left corner and check [Merge and center labeled cells] in the pop-up menu.

After that, switch to the [Design] tab above, select not to display subtotals in [Subclassification], select disable rows and columns in [Total], and in [Report Layout] Select Display in table format.

Finally copy this column of the data dialysis table to the name column, and that’s it. This method is suitable for those data tables where the name column is messy at the beginning. If it is unified from the beginning, then you can directly merge and center the cells.

The above is the detailed content of How to merge similar items in Excel. For more information, please follow other related articles on the PHP Chinese website!