I'm not sure exactly what you're after here, as I don't know what event date correlates to those columns. There's no common date between those 4 columns.
To get the last event date, use a summarise on that column and get Max.
If you transpose all the data, then you can join on that Max_date and the [Value] field of the transposed data. The [Name] field will be your column name.
If you are looking for matches that aren't exact, then it requires a lot more logic.
