I need hellp to split out a column of data into 3 fields
I need hellp to split out a column of data into 3 fields
(OP)
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
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





RE: I need hellp to split out a column of data into 3 fields
(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>