How to show cells in first two when filtering a table?

Hello everyone, I have created a spreadsheet to list the tasks I'm working on. I mark them complete with a date as I go. I would like to figure out a way to show the data in the first 2 columns (Job No. & Job Name) to still be visible when I filter the table by 'Completed' or 'Urgent'.

Is there a way to maybe lock those cells without having to repeat them in every row?

Any help will be greatly appreciated. I am attaching my spreadsheet to help explain the issue.

[Edit] removed attachment without solutions