Merging Same SKU but different Product Name

[Anzrey]

Hi,

I been searching for the community but is either I don't understand or I am unable to found what I wanted. I need some help regarding to the issue I am facing right now where after I ran the workflow, multiple row same sku didn't merge together because of the product name is different.

Here are some input data to represent my data:

SKU	Product Name	Quantity
123	abc	1
123	abcd	2
123	abcde	3
456	efg	4
456	efgh	5

The output I desire is:

SKU	Product Name	Quantity
123	abc	6
456	efg	9

Thanks in advance.

[Qiu · Accepted solution]

@Anzrey 

I believe Summarize Tool is what we need here

[Anzrey]

Thanks for the reply, didn't know it was that simple lel.

[Qiu]

@Anzrey 
Dont worry, everyone had his start.
Glad to help and thank you for the accept mark😁