It has already been mentioned, but you should:
GROUP BY MANUFACTURER; THEN GROUP THOSE UNKNOWN
You obviously have a number of Adams and Vikings. There are probably a couple Meuccis, Hueblers, Palmers, etc. Group each of these together. Then Take all the others that have no markings as a...