C D L O P Q R
H, AL A, AL A A P SF H, AL
1.0, 1.0 1.0, 1.0 7.50 8.5 0.00 0.00 1.0, 2.0

As you can see, €œA€� (shown in columns D and L) and €œAL€� (shown in columns C
and D) are in two separate columns;

I would like to show their totals in two separate columns, i.e, O (totals of
all €œA€�) and R (totals of €œAL€�) in the example above.