how to copy multiple cells into one cell
 

This site helps me a lot during my intership. Thanks for everyone post here. I got a problem now, quite complicated.
I have two workbooks and I am copying data from LP to MS. In LP the data is arraged like this:
dates product u97 u95 mt no (six columns, seperate by space)
01/08 quantity 80 90
08/08 quantity 89
09/01 quantity 87
The format in the destination is like:
dates product (two columns)
01/08 u97 = 80 mt=90 (in one cell, not merge)
08/08 u95 = 89
09/01 no = 87

Can anyone help me write a macro to run this? I really appreciate your help! Thanks a lot a lot!!