Select Code to Download

Select or download this

 id name dept date_joined email date_sent
       1  P1    Test   12/10/14  Y    12/11/14 10:53:45
       1  P1    Test2  1/1/14    Y    1/05/14 05:25:34
       2  P2    Test  3/1/14  N    Null
       2  P2    Test   8/1/14  Y    8/05/14 11:28:28
       3  P2    Test3  10/1/14 N    Null

Select or download this

Desired Output is: 
   id   name  Test             Test2          Test3       Y_email  N_E
+mail
...
Basically, trying to transpose and flatten it to get one row per recor
+d.

Any ideas how I can do this?