I cannot just filter them out of the sheet because I need to add the sum of the them
like
A0 2555
A0 2241
A0 3432
B2 2135
B2 2576

A0 = SUM OF ALL A0
B2 = SUM OF ALL B2

I just need to column which will list A0 B2.B3,B4....will ignore and skip repeats
I already know how to get sum of them