Sql server table result in different format

See more:

SQL

server

Hello experts . I have a requirement like:

I have this type of table result :

Qid  AnsId   AnsCount 
2     1      1
2     2      3
2     3      NULL
2     4      NULL
1     5      2
1     6      1
1     7      NULL
1     8      1

but i want it in the following format :

Qid   Ans1  Ans2   Ans3  Ans4
2      1     3      0     0
1      2     1      0     1 

Thank you in advance.