I have a table with the headings; job number, title, and option (A/E).
I want to pull in the jobs which are only option A into a new worksheet table.

So my first table may have

Job No Title Option
1234 Site 01 A
2345 Site 02 E
3456 Site 03 E
4567 Site 04 A

My new table should only have:

Job No
1234
4567

Kind regards
Dylan