pivot sqlserver 条件_SQLServer-同一列上有多个PIVOT

I'm curious to know if I can perform multiple PIVOT on same column in sql server like this:

WITH T(ID, NAME, MSNAME, PLANED, ACTUAL)

AS (

SELECT 1, '45rpm', 'Raised to Supplier', '2014-12-17', '2015-12-17' UNION ALL

SELECT 1, '45rpm', 'Base Test Date', '2014-12-18', '2015-12-18' UNION ALL

SELECT 1, '45rpm', 'Washing Approval', '2014-12-19', '2015-12-19'

)

SELECT ID, NAME

, MAX(CASE WHEN MSNAME LIKE 'Raised to Supplier' THEN PLANED END) AS 'Raised to Supplier (PLANED)'

, MAX(CASE WHEN MSNAME LIKE 'Base Test Date' THEN PLANED END) AS 'Base Test Date (PLANED)'

, MAX(CASE WHEN MSNAME LIKE 'Washing Approval' THEN PLANED END) AS 'Washing Approval (PLANED)'

, MAX(CASE WH