Transpose MySQL query - need rows into columns

Transpose MySQL query - need rows into columns

References

Reference NO 1

http://stackoverflow.com/questions/13581482/transpose-mysql-query-need-rows-into-columns

Reference NO 2

http://stackoverflow.com/questions/16449754/transpose-rows-in-mysql-with-three-columns

Reference NO 3

http://forums.mysql.com/read.php?10,369604,369604

Reference NO 4

http://forums.devshed.com/mysql-help-4/transposing-rows-to-columns-598966.html

Reference NO 5

http://data-aegle.blogspot.com/2012/04/how-to-transpose-rows-to-columns-in.html

Reference NO 6

http://bytes.com/topic/access/answers/833812-sql-query-transpose-data-rows-into-columns

Reference NO 7

http://codenaut.blogspot.com/2012/03/mysql-select-into-groupconcat.html

Reference NO 8

http://www.sitepoint.com/forums/showthread.php?549636-Row-to-Column-Tranposition