行转列时将某结果列变为字段

数据库版本 MySQL 5.1.41-community-log测试代码
DROP TABLE IF EXISTS `t_test`;
CREATE TABLE IF NOT EXISTS `t_test`(
  `c` INT(1) NOT NULL,
  `s` INT(1) NOT NULL,
  `q` INT(1) NOT NULL DEFAULT '0'
) ENGINE=InnoDB;INSERT INTO `t_test` VALUES
(1,1,10),
(1,2,11),
(1,3,12),
(1,4,13),
(2,1,14),
(2,2,15),
(2,3,16),
(2,4,17),
(3,1,18),
(3,2,19),
(3,3,20);SELECT CONCAT(`c`,`s`),`q` FROM `t_test`;
+-----------------+----+
| CONCAT(`c`,`s`) | q  |
+-----------------+----+
| 11              | 10 |
| 12              | 11 |
| 13              | 12 |
| 14              | 13 |
| 21              | 14 |
| 22              | 15 |
| 23              | 16 |
| 24              | 17 |
| 31              | 18 |
| 32              | 19 |
| 33              | 20 |
+-----------------+----+期望结果，把CONCAT(`c`, `s`)这个字段(可以确定这个2个字段CONCAT后值唯一)的数据变为字段列，`q`字段的数据变为对应字段的数据
+----+----+----+----+----+----+----+----+----+----+----+
| 11 | 12 | 13 | 14 | 21 | 22 | 23 | 24 | 31 | 32 | 33 |
+----+----+----+----+----+----+----+----+----+----+----+
| 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 |
+----+----+----+----+----+----+----+----+----+----+----+