@Charlieface has already shared great options.Here is another one using Case statements only.I have used postgres as an example but let me know which db you are using so if needed syntax can be changed.
SELECT DISTINCT ON (Organization)
Organization,
Year,
Target
FROM manufacturer_status
WHERE Target IN ('Achieved', 'Partial')
ORDER BY Organization,
CASE
WHEN Target = 'Achieved' THEN 1
WHEN Target = 'Partial' THEN 2
END;