It's a breeze with a pivot table! And, this is a great chance to learn this super-powerful feature of Excel with your simple example data.
You already have your data in 2 columns. You should then put names at the top of your 2 columns, such as:
Next (in Excel 2007 or higher), choose "Insert", "Pivot Table". This brings up the "Create PivotTable" dialog box.
In the "Create Pivot Table" dialog box, in the top section, select your 2 columns of data to include the column names. In the lower section, you can specify the location of your new pivot table. If you choose an "Existing Worksheet", just be sure that you aren't overlapping any cells that are already occupied. Click "OK".
This brings up a "Pivot Table Field List" form.
Using the column names shown above, you would drag the "Ltr" from the "Choose fields..." section into the "Row Labels" section. You would drag the "Val" into the "Sum Values" section. All done!
One final trick. If you only need the layout of the resulting pivot table, but don't need all the functionality (filtering, drag-and-drop, etc), click anywhere in the pivot table. Then on the Ribbon, choose "Options", "Select", "Entire Pivot Table". Then, "copy" and then in a desired location, "Paste Special", and choose "Values". You'll get the layout only at that point.
Hope this helps!