I need hellp to split out a column of data into 3 fields

[Tamania1]

Hello everyone

I have some data I need help in splitting out.

I have a column - for argument sake shows as A, B and C and I have a second column that has figures attached to this data.

I need to sum values where column 1 = A then create another column for values = B and so on. Can anyone assit me with this please?

Thanks for you help.

Tax

 

[rtmpxr]

select distinct
(select sum(column2) from <table> where column1='A') AS A,
(select sum(column2) from <table> where column1='B') AS B,
(select sum(column2) from <table> where column1='C') AS C
from <table>