Translating Access Cross-Tab query into T-SQL?

Hello,

I am wondering if someone could give some advice about how I could translate the following query in MS Access into T-SQL.  Any help is greatly appraciated.

Thanks

------------------------------------------------------------------------------------

TRANSFORM Avg(A.Response) AS AvgOfResponse

SELECT A.QuestText, A.SubQuestText

FROM TableName A

WHERE A.Response Is Not Null

GROUP BY A.QuestText, A.SubQuestText

ORDER BY A.QuestText, A.SubQuestText

PIVOT A.[Ethnicity Group]

-------------------------------------------------------------------------------------------------------------------------------