Count number of records in table in SQL Server

I wrote the following query

SELECT t.TestID,t.TagID,t.C_Date
FROM
    (
      SELECT ROW_NUMBER() OVER (PARTITION BY (TagID) ORDER BY C_Date DESC) Row_No,TestID,TagID,C_Date
      FROM tblPregTest where P_Result='Positive'
      GROUP BY TestID,TagID,C_Date
    )t
WHERE Row_No = 1 AND t.TagID NOT IN (SELECT DISTINCT TagID FROM tblCalving)
ORDER BY t.TestID

it is showing me correct data like that

Now, I want to display data like that

I am unable to get required out. how to get solution pls.