Hey,

Here's an example of my mySQL database:

ID | Color
1 | Blue
1 | Orange
2 | Blue
3 | green
3 | Blue
...

I want to show how many colours ID is available in (in a table) e.g.

ID | Blue | Orange | Green
1 | yes | yes | no
2 | yes | no | no
3 | yes | no | yes

Thanks for your help!