Selecting rows with the multi highest date

I have some values in my table like this,

Main Table

I want to select only those with the latest/highest date, The result will be like the picture in below:

Result Table

I already try with union but it didn't meet my expectations

I got the query to make the result like that.

This my SQL query:

SELECT table1.jobno AS 'Job. No',  

(SELECT CONCAT(`search_date_1`, ' - ', `last_search_by_1`) FROM table1 WHERE id IN (SELECT MAX(id)  FROM table1 WHERE jobno = table1.`jobno` AND search_by_1 != '')) AS 'Search Option 1',

(SELECT CONCAT(`search_date_2`, ' - ', `search_by_2`) FROM table1 WHERE id IN (SELECT MAX(id) FROM table1 WHERE jobno = table1.`jobno` AND search_by_2 != '')) AS 'Search Option 2', 

(SELECT CONCAT(`search_date_3`, ' - ', `search_by_3`) FROM table1 WHERE id IN (SELECT MAX(id) FROM table1 WHERE jobno = table1.`jobno` AND search_by_3 != '')) AS 'Search Option 3'

FROM `table1` AS table1 

GROUP BY table1.jobno