sql在同一个表中连接2行

I have the following table:

我有下表:

Name   Type     Value
---------------------
mike   phone    123    
mike   address  nyc    
bob    address  nj    
bob    phone    333
Name   Ty