Is there a way to use PIVOT syntax to accomplish the following? I have table_A and want to have a result like table_B.  I can accomplish this by using a WHILE loop with a counter a loop 12 times to get my data in the format I want in table_B.  Wondering if there was a cleaner way.  Thank you!
--Unpivot the table.

SELECT Location, Account,Dept, Year, Month, Amount 
FROM 
   (SELECT Location, Account,Dept, Year, Month, Amount, January ... Dec
   FROM Table_A) p
UNPIVOT
   (Amount FOR Month IN 
      (January, Feb ... Dec)
)AS Table_B;
GO


reference: link