Desired Output is: 
   id   name  Test             Test2          Test3       Y_email  N_Email
   1    P1   12/10/14,8/1/14  1/1/14,3/1/14 10/1/14  12/11/14 10:53:45,1/05/14 05:25:35,8/05/14 11:28:28  Null
   2    P2  1/1/14,3/1/14       null         10/1/14 Null, Null

Basically, trying to transpose and flatten it to get one row per record.

Any ideas how I can do this?