Getting comma separated values as column headers MySQL

I have set of comma separated values and I开发者_运维知识库 want to display them as columns. To elaborate it more here's an example what I am trying to do.

I have column test which has values as ('ab','bc','cd','ac','ba').......

so I want them as:-

date         ab     bc       cd       ac      ba
2011-01-01   1      2         3        4      5
2011-02-01   2      4         6        8      10 and so on

How to accomplish this?