Populate asyncronous data

I'm trying to work out a method (formula if possible, otherwise VBA if not) to populate date from one table to another where the data is not in similar table formats. Sample attached for any ideas.

Thanks