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.