Why would someone want to convert columns into rows (ie pivoting)? Which problem does it solve?
I found some links, but did not get satisfactory answers to the questions.
http://codeghar.wordpress.com/2007/11/03/pivot-tables/
http://msdn.microsoft.com/en-us/library/ms177410%28SQL.105%29.aspx