I want the values in column label to be displayed in the a-axis. Is
there an easy way to transform the data:
Here is the input data:age_code | label | count
----------+-------+-------age_1 | 30k | 1age_1 | 50k | 2age_1 | more | 2age_2 | 40k |
2age_3 | 40k | 1
I want the result to be:
age_code | 30k | 40k | 50k | more
-----------------------
age_1 | 1 | | 2 | 1
age_2 | | 2 |
age_3 | | 1 | |
Is there any easy way to do the job or do I have to write a PL/pgSQL
function?
Hans