arrange data

Hello

I have two sets of data which contain dates, names,currencies and two values. First set of data has less rows then the other one. I would like to arrange data so that the same date, name and currency in one set are in the same row as in the other.

I attached a file to make it easier to explain what I want. In the columns A-L are row data, and in the columns V-AG is the result that I want.

I managed to create a macro that succesfully arranges dates, but I need all three: dates, names and currencies to be in a same row.

Is there a macro that could do that?