LtZ0kUP9

1create table if not exists `new_table` as
2    select * from (
3        select descrip,
4        max(case when ID = 1.01 then value else 0 end) 'collumn'
5        from(
6            select ID, `JUL-08` value, '1' descrip 
7            from original_table
8            union all
9            select ID, `AUG-08` value, '2' descrip
10            from original_table
11            union all
12            select ID, `SEP-08` value, '3' descrip
13            from original_table
14            union all
15            select ID, `OCT-08` value, '4' descrip 
16            from original_table
17            union all
18            select ID, `NOV-08` value, '5' descrip 
19            from original_table
20            union all
21            select ID, `DEC-08` value, '6' descrip 
22            from original_table
23        ) src
24        group by descrip
25    ) as `new_table`;
26	
271, 2, 3, 4, 5, 6.
28	
291, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 2, 3, 4, 5, 6, 7, 8, 9.