Combine multiple rows into one and seprate columns by space deliminator

Hi

I have attached Both excel sheets sample data and the resulting data 01

In this i want to combine multiple rows into one row and the separate columns by space deliminator..


Thanks..