Combine Same Values/Same Data Or Duplicate Rows In Excel!!
Tags: combinethesamevalues, kutoolsexceltutorial, kutools
Published: 2020-11-16 07:31:35

---
title: Combine Same Values/Same Data Or Duplicate Rows In Excel!!
published: true
date: 2020-11-16 06:40:11 UTC
tags: CombinetheSameValues,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/combine-same-values-same-data-or-duplicate-rows-in-excel/
---

In this article, we will explore the steps to **Combine the Same Values/Same Data or Duplicate Rows in Excel Office 365** using **Kutools.** Get an official version of MS Excel from the following link: **[https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)**

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
## Combine Rows with Same Values/Data:

To combine rows with the same values in Excel, do as follows.

- Let’s consider an example to do this task.
- In the below image, you can see the **items, quantity,** and **name** columns. We are going to **combine quantity values** based on duplicate values in **column items** & **column name**.
- You need to **select the data range** that you want to combine duplicates.

![Select the range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Select-the-range-1.png)<figcaption id="caption-attachment-17244">Select the range</figcaption>

- Then, on the **Kutools Tab, select** the **Merge**  **& Split** option, **choose** the **Advanced Combine Rows** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-5.png)<figcaption id="caption-attachment-17245">Kutools Tab</figcaption>

- It will open the **Advanced Combine Rows Dialog Box**.
- You need to specify the **column items** & **column name** as the **Primary key.**
- To do that, you need to **select the column** name and **click** the **Primary Key** option to check the duplicates.
- Then, **select** the **column quantity** and **click** the **Combine** button to merge the data. You need to **choose** the **separator** to merge them.

![Advanced Combine Rows Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Advanced-Combine-Rows-Dialog-Box.png)<figcaption id="caption-attachment-17246">Advanced Combine Rows Dialog Box</figcaption>

- Finally, **click** the **OK** button to apply the operation.
- You will get the result as shown in the below image.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Result-12.png)<figcaption id="caption-attachment-17247">Result</figcaption>

## Steps to Combine Duplicate Rows and Sum/Average the Values:

If you want to combine duplicate rows and sum/average the values, then follow the below steps.

- In the below screenshot, you can see the columns **items, quantity,** and **name.** We are going to **sum** the column **quantity** based on the duplicate values in the column **items.**
- You need to **select the data range** that you want to combine duplicates.

![Select the data range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-17.png)<figcaption id="caption-attachment-17248">Select the data range</figcaption>

- Then, on the **Kutools Tab, select** the **Merge**  **& Split** option, **choose** the **Advanced Combine Rows** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-5.png)<figcaption id="caption-attachment-17245">Kutools Tab</figcaption>

- It will display the **Advanced Combine Rows Dialog Box.**
- In the Column list, you need to **select the items** column and **click** the **Primary Key** option to check the duplicate values.
- Then, you need to **select** the column **quantity** and **click** the **Calculate** option, then choose one function ( we choose **Sum)** from the drop-down list.

![Advanced Combine Rows Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/2-17.png)<figcaption id="caption-attachment-17249">Advanced Combine Rows Dialog Box</figcaption>

- Finally, **click** the **OK** button to get the result.
- You can see the duplicate values are merged and their values will be added as shown in the below image.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Output-4.png)<figcaption id="caption-attachment-17250">Output</figcaption>

### Note:

- **Combine –** With this option, you can sum, average, count, and product the values. You can also select the maximum & minimum from the duplicate values.

## Combine Duplicate Rows & Keep the First or Last Data of Column:

If you want to combine duplicate rows and keep the first or last data of a column in Excel, follow the below instructions.

- In the below image, you can see the input columns **items, quantity,** and **name.**
- We are going to get the **last data** of the **column quantity** based on the duplicate values in the **column items.**
- You need to **select the data range** that you want to combine duplicates.

![Select the data range](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/1-17.png)<figcaption id="caption-attachment-17248">Select the data range</figcaption>

- Go to the **Kutools Tab, select** the **Merge**  **& Split** option, **choose** the **Advanced Combine Rows** option.

![Kutools Tab](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/Kutools-Tab-5.png)<figcaption id="caption-attachment-17245">Kutools Tab</figcaption>

- It will display the **Advanced Combine Rows Dialog Box.**
- In the **Column** section, you need to **select** the column **items** and **click** the **Primary key** option to check for duplicate values.
- Then, **select** the **quantity** column and **click** the **Keep 1st** or **Keep Last** option as you need.

![Advanced Combine Rows Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/3-16.png)<figcaption id="caption-attachment-17251">Advanced Combine Rows Dialog Box</figcaption>

- At last, **hit** the **OK** button. You will see the duplicates are combined and their first or last value will be kept as well.

![Output](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/11/4-13.png)<figcaption id="caption-attachment-17252">Output</figcaption>

### Note:

- **My data has headers –** If you check this option, it will ignore the headers of the data range.
- **Use formatted values –** This option will keep the formatting of the values after combining the duplicate cells.

## A Brief Summary:

In this article, you can easily understand the steps to **Combine the Same Values/Same Data or Duplicate Rows in Excel Office 365** using **Kutools. ** Don’t forget to drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!