How to Copy Data from multiple records in one table to a single record in another  ?

Discussion created by binu.alexander on Jan 17, 2016
Latest reply on Jan 17, 2016 by binu.alexander

I have   a  one table with  following data Screen Shot 2016-01-18 at 6.54.19 AM.png


I want to convert it into this format in another table  like this

Screen Shot 2016-01-18 at 7.01.56 AM.png


I am trying using Execute SQL  ,    Sample file is attached  .


Any help will be appreciated ...