PowerQuery: How can I concatenate grouped values?
You can use the GUI to do it this way: Select your LetterColumn and then Transform / GroupBy: Select Add Column / Custom Column: Click opposing arrows at top right of new Custom column to Extract Values from new Custom column: Remove AllData column.