How do i project 3 different columns from 3 rows ?

Question

How do i project 3 different columns from 3 rows without creating temp table.

 

In my table, I have 3 columns name type, identifier and value 

 

type	identifier	value
myApp	AppOwner	The Owner
myApp	AppDev	The Dev
myApp	AppTester	The Tester

 

How do i write query so that i can get data back as 

Owner	Dev	Tester
The Owner	The Dev	The Tester