The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% Full feature free trial 30-day, no credit card required! Get It Nowĭemo: delete rows based on duplicates in one column in Excel Kutools for Excel- Includes more than 300 handy tools for Excel. And now all rows are deleted based on duplicates in the specified column, and simultaneously other columns are combined or calculated based on the duplicates in the specified column too. In our case we select the Amount column and click the Calculate > Sum.ģ. In the Column section, select the column where you will calculate (sum, average, count, etc.) values based on duplicates in the specified column, click the Calculate and then select a calculation type from the drop down list. In our case we select the Price column and click the Combine > Comma.
In the Column section, select the column where you will combine values based on duplicates in the specified column, click Combine and then specify a separator from the drop down list. (1) In the Column section, select the column which contains the duplicate values, and click the Primary Key In the opening Advanced Combine Rows dialog box, please do as follows: