Forum Discussion
Nextif Function and Mail Merge
I'm not sure how you are familiar with Power Query. Here we query the source, Group By names, aggregate other columns using concatenation of values for each name with line break in between, return result into Excel sheet. To make line breaks visible we shall apply Wrap text in formatting of these cells.
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.
- SergeiBaklanAug 27, 2022Diamond Contributor
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], ",")
- DataMattSep 23, 2022Copper Contributor
@SergeiBaklan thank you so much! Used your suggestion and accomplished what I needed to.