Hello,

I've found some documentation on transposing tables, generating crosstabs
(e.g. http://dev.mysql.com/tech-resources/...t_version.html).
To be honest I've to admit that I tried to figure out how it works, but I'm not able to adopt it to my problem.

My starting table looks like:
mnr kw Produktion Stillstand Wartung
63210 25 6143 183 0
63210 26 6410 116 0
63210 27 6817 160 16
63210 28 7481 149 0
63210 29 4345 136 213
63210 30 5168 162 0

What I want is:

mnr 63210 63210 63210 63210 63210 63210
kw 25 26 27 28 29 30
Produktion 6143 6410 6817 7481 4345 5168
Stillstand 183 116 160 149 136 162
Wartung 0 0 16 0 213 0

How can I achieve this?

regards
Volker