Help in converting data in multiple rows and columns to single row

Hi All,

I have a data running over few thousand rows. The data is grouped by first column. I need to convert the multiple rows to one single row. I have attached two excel sheets - one for what I have & one for what I want...any help would be highly appreciated...I need to do this fast!!

Thanks a lot!What I Want.xlsxWhat I Have.xlsx

learner, please open just one thread.
This one is closed.

Continue in this one: http://www.excelforum.com/excel-2007...ingle-row.html