How to combine formula message based on criteria

[richleeb2]

Hi!  This one is a little tricky.  The formula tool has an email message includes data from the following columns "Account" and "Reason" for each person.  The output below is what I am getting, but I don't want to send 3 emails to the same person.  How do I combine so each person has one row and all the Accounts and Reasons are in one email?

Current Output

joe.smith@test.com

Action Needed

Your answers for the following account are invalid: Account: Account A Reason: Question 1 cannot be blank

joe.smith@test.com	Action Needed	Your answers for the following account are invalid: Account: Account B Reason: Question 1 cannot be blank
joe.smith@test.com	Action Needed	Your answers for the following account are invalid: Account: Account C Reason: Question 2 cannot be blank

Desired Output

joe.smith@test.com

Action Needed

Your answers for the following account are invalid: Account: Account A Account B Account C Reason: Question 1 cannot be blank, Question 2 cannot be blank

[binuacs]

@richleeb2 Can you provide the input file for this?

[richleeb2]

Here

[binuacs]

@richleeb2 One way of doing this with the summarize tool