I have columns like so:

SW1 Amount Data
SW18 Amount Data
SW19 Amount Data
B3 Amount Data
B22 Amount Data

etc

Basically I just want to group the data by the first letter bit, so B3
and B22 is summed just becomes B data, and SW1/SW18/SW19 is summed and
becomes SW data.

Having trouble because the letter and number size varies but I'm sure
this is easy to do?

Thanks