, sum( case when datepart(month,VisitDate) = 1 then 1 end ) AS JAN

, sum( case when datepart(month,VisitDate) = 2 then 1 end ) AS FEB

, sum( case when datepart(month,VisitDate) = 3 then 1 end ) AS MAR

, sum( case when datepart(month,VisitDate) = 4 then 1 end ) AS APR

, sum( case when datepart(month,VisitDate) = 5 then 1 end ) AS MAI

, sum( case when datepart(month,VisitDate) = 6 then 1 end ) AS JUN

, sum( case when datepart(month,VisitDate) = 7 then 1 end ) AS JUL

, sum( case when datepart(month,VisitDate) = 8 then 1 end ) AS AUG

, sum( case when datepart(month,VisitDate) = 9 then 1 end ) AS SEP

, sum( case when datepart(month,VisitDate) = 10 then 1 end ) AS OCT

, sum( case when datepart(month,VisitDate) = 11 then 1 end ) AS NOV

, sum( case when datepart(month,VisitDate) = 12 then 1 end ) AS DEC

FROM Table1

GROUP BY Year([VisitDate])

ORDER BY Year([VisitDate]);