Is there any feature in MSSQL similiar to PIVOT table of Excel

I have a detailed table, which has structure as below, 

 Column Name    Data Type
Actor    Text 
Action     Text
Events  Number

The data stored in the table is as below,

 Node 1     Print  3
 Node 1  Fax  2
 Node 2  Fax   3
 Node 6  Email  1

Until my data was in Excel i was easily able to get the output as below, now i had transferred my backend to MSSQL and trying to get the similar output. 

 Actor  Print  Fax  Email
 Node 1  3  2  
 Node 2    3  
 Node 6      1

Any help will be highly appreciated.