SELECT
*
FROM
(
SELECT *
FROM
(
SELECT 'Female' AS Gender, 11 AS Jan, 13 AS Feb, 13 AS Mar
UNION SELECT 'Male' AS Gender, 35 AS Jan, 43 AS Feb, 43 AS Mar
) p
UNPIVOT (
C FOR [Month] IN (Jan, Feb, Mar)
) AS unpvt
) p
PIVOT (
SUM(C) FOR Gender IN (Female, Male)
) pvt
See also
Using PIVOT and UNPIVOT[
^]