Merging rows when column values (email) match

[spilltime]

I am working with a set of data from multiple sources. I have developed a workflow that has provided me the answer I needed at a high level but now I want to look at it in a more detailed manner. (Below is my current workflow)

Below is a screenshot of both what I am getting from the path on the bottom right and what I want my data to look like. When there are multiple matching email addresses, I need the columns to merge. I have gone through a few community posts but have not been successful at finding my answer. 

[CharlieS · Accepted solution]

Use a Summarize tool to "GroupBy" email and for TC1, TC2, TC3 use "Sum" or "Max", whichever is appropriate. 

Check out the attached workflow for an example. 

[spilltime]

Charlie thank you. 

I cant believe I overlooked that. It works exactly as needed!