How to convert columns into rows in MS Access
SELECT "NoOf_A" AS Type_ofCValue, NoOf_A AS [Value] FROM T1

UNION

SELECT "NoOf_B" AS Type_ofCValue, NoOf_B AS [Value] FROM T1

UNION

SELECT "NoOf_C" AS Type_ofCValue, NoOf_C AS [Value] FROM T1

UNION 

SELECT "NoOf_D" AS Type_ofCValue, NoOf_D AS [Value] FROM T1;