Rearranging Data in an MS Access 2007 table into a new table format/Result Output
Yes, it can be done, using UNION ALL:

SELECT [Name] &amp; " Math" AS col1, tab1.Math FROM tab1
UNION ALL
SELECT [Name] &amp; " Science" AS col1, tab1.Science FROM tab1
UNION ALL
SELECT [Name] &amp; " Reading" AS col1, tab1.Reading FROM tab1
UNION ALL
SELECT [Name] &amp; " Civics" AS col1, tab1.Civics FROM tab1
Order BY 1;