GROUP_CONCAT question

[Steve Delaney]

I am trying to extract/transpose some data, and from other posts I think GROUP_CONCAT may be the answer, but perhaps a little too complicated yet for me!

I have this information in a table:

Order | Product | Option | Value |
1 | 10 | Colour | Red |
1 | 10 | Size | Large |
1 | 10 | Sleeve | Short |
2 | 10 | Colour | Blue |
2 | 10 | Size | Small |
2 | 10 | Sleeve | Long |

and want it to be extracted like this:

Order | Product | Colour | Size | Sleeve |
1 | 10 | Red | Large | Short |
2 | 10 | Blue | Small | Long |

I've managed to get all the Values crammed into one column, with the values separated by a symbol (like this: | 1 | 10 | Red, Large, Short | ), but it would be much better to have them in separate columns.

Can someone help me with this?

Steve