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!
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!
