>;with cteUnpvt AS (SELECT * FROM
>   (SELECT classification, p1, p2, p3, p4, p5
>   FROM ClassCounts WHERE LocID='N-18') p
>UNPIVOT
>   (VehicleCount FOR [TimePeriod] IN 
>      (p1, p2, p3, p4, p5)
>)AS unpvt)
>
>select * FROM cteUnpvt PIVOT (max(VehicleCount) FOR Classification IN ([1],[2],[3],[4],[5],[6])) pvt
>