I am trying to find result of sort data in table with specific criteria
for example :
The picture of excel-table that i trying to figure it out

yellow is ALL-JOB fill by user
RED is Unfinish JOB sort by "START DATE"
Green is Completed JOB sort by "END DATE" and "JOB ID"
i need to sorting data in yellow table and show result in red/green table ,smallest to largest
Any help would be greatly appreciated. Thank you so much in advance.
ps.My English is not good. Please forgive me if I make grammatical mistakes.
for example :
The picture of excel-table that i trying to figure it out

yellow is ALL-JOB fill by user
RED is Unfinish JOB sort by "START DATE"
Green is Completed JOB sort by "END DATE" and "JOB ID"
i need to sorting data in yellow table and show result in red/green table ,smallest to largest
Any help would be greatly appreciated. Thank you so much in advance.
ps.My English is not good. Please forgive me if I make grammatical mistakes.