Reorganising raw data in Excel

[fbert]

Hi, I have a problem that I can't wrap my head around:

My data looks like this:


print screen windows 7

What I want is to allocate the "year founded" to the corresponding "Buyer/investor". So for the values/strings in "year founded" I need to
a) allocate each to the corresponding value in the "Buyer/investor" columns;
b) extract the year

I have no problem isolating the years from the values in "year founded" - what throws me off is that as in the first row, sometimes the order is mixed up. Does anybody have any advice on this?

Thanks in advance for any help!