Forum Discussion
Nextif Function and Mail Merge
Hello, I am trying to get a mail merge where I want separated email to be sent to a list of accounts. I would like James Green to receive one email only stating: 21/11/2018 89 26/12/2018 3...
SergeiBaklan I am trying to solve the same question Chris had. I am not very familiar with Power Query. I have been able to Group By the necessary column but I can't find an option to aggregate via concat the other columns to later wrap. I've tried clicking on advanced settings but I only see options to sum, count, etc. Thank you for your time.
You may start from any function in user interface, e.g. from SUM, and after that change it in formula bar on required. For example, if List.Sum([A]) is generated, it could be changed on Text.Combine([A], ",")
@SergeiBaklan thank you so much! Used your suggestion and accomplished what I needed to.