Pivoting columns in SQL

Transact-SQL
3

Thank you Bitsmed. It works. Is there a dynamic way to achieve this goal rather than hard coding TaskName and Type in Case Statement.?