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 |
