I have the following table:
Name Type Value
---------------------
mike phone 123
mike address nyc
bob address nj
bob phone 333
I want to have the result like this:
name value value
-------------------
mike nyc 123
bob nj 333
How can I do it?