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.