Merging common rows in a data set

[Ro2]

Hi, I'm hoping the community can help me with this little issue.

I have a large data set and some of the rows are common and should be added or merged to form one record. I've an simple example below: 

I need to combine the highlighted rows into one as well as any other common rows elsewhere in the file. Anyone have and idea what tool could help?

[markcurry · Accepted solution]

Hi @Ro2 you should be able to do this with the Summarize tool.

Group By ORG, Type, Part Number and Date, and Sum the Amt field.

Hope that helps.

[Emil_Kos · Accepted solution]

Hi @Ro2,

I have created a mock workflow for you:

Input:

Oputput:

Workflow:

If this was helpful please mark it as an answer! 

[Ro2]

Solved it with summarize tool.

[Ro2]

Thanks Mark

[Ro2]

Thanks Emil

[Emil_Kos]

Hi @Ro2

Np! Happy to help!