Supposing you have a range as shown in the following screenshot, and you want to merge the column Quantity data based on duplicate values in the column Product and column Name. See screenshots:Ĭombine rows with same values / same data
Super Filter: Create advanced filter schemes and apply to any sheets Sort by week, day, frequency and more Filter by bold, formulas, comment.Ģ007-2019 and 365 Supports all languages Easy deploying in your enterprise or organization.Ĭlick Kutools > Merge & Split > Advanced Combine Rows. Paste Skipping Hidden/Filtered Rows Count And Sum by Background Color Send Personalized Emails to Multiple Recipients in Bulk. Split Tools: Split Data into Multiple Sheets Based on Value One Workbook to Multiple Excel, PDF or CSV Files One Column to Multiple Columns. Merge Tools: Multiple Workbooks and Sheets into One Merge Multiple Cells/Rows/Columns Without Losing Data Merge Duplicate Rows and Sum. More than 20 text features: Extract Number from Text String Extract or Remove Part of Texts Convert Numbers and Currencies to English Words. Reuse Anything: Add the most used or complex formulas, charts and anything else to your favorites, and quickly reuse them in the future. The result is total sales summarized by product, starting from cell E1.Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by If the data set doesn’t have a header row, you don’t need to select Top row. In the Consolidate window, check Top row, and Left column, and click OK. Select the data range you want to consolidate (e.g., B1:C17), and click Enter.Ĥ. In the Consolidate window, leave the default Function ( Sum), and click on the Reference icon to select a range for consolidation.ģ. 
Select a cell where you want to get a new data range (e.g., E1), and in the Ribbon, go to Data > Consolidate.Ģ. You can combine the data and get a total sales amount for every product in a separate range, next to the original one.ġ.
In the following example, you have products in Column B (including duplicates), and their sales amounts in Column C.
For example, if you have sales by product in a sheet (as shown below), you may want to summarize sales for every product. In Excel, there is often a need to combine duplicate rows in a range and sum them in a separate column. In this article, you will learn how to combine duplicate rows by summing them in Excel.
0 kommentar(er)
