How to combine formula message based on criteria

Question

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.comAction Needed Your answers for the following account are invalid:

Account:

Account A

Reason:

Question 1 cannot be blank

joe.smith@test.comAction Needed Your answers for the following account are invalid:

Account:

Account B

Reason:

Question 1 cannot be blank

joe.smith@test.comAction Needed Your answers for the following account are invalid:

Account:

Account C

Reason:

Question 2 cannot be blank

Desired Output

joe.smith@test.comAction NeededYour 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

binu_acs · Answer

@richleeb2 One way of doing this with the summarize tool

Answer_combined_0824.yxmd

richleeb2 · Answer

Here

Book1.xlsx

binu_acs · Answer

@richleeb2 Can you provide the input file for this?