Forum Discussion
Solved
Grouping by a column and merging multiple cell values into a single cell separated by commas
I have a table with the list of accounts and their corresponding account managers. Some accounts have multiple account managers thus the account number is repeated multiple times in the report. I'm t...
Maybe you want to do this with Power Query.
If you are loading the data from an external source (ETL) then PQ is the hand-down winner. If the data is already loaded within a 365 workbook, then formulas will perform the task perfectly well.
= MAP(UNIQUE(acName),
LAMBDA(ac, TEXTJOIN(", ",,FILTER(acMgr, acName=ac)))
)