Thank you for your suggestion, but I am still having some issues.
Are you saying it should be something like this?
PEEK('Classifier'),0) AS NewField
order by ProjectType,Classifier desc;
It is only populating some of the values.
It must have had some fields with the data filled out, so the same value repeated often.
I got it to work using the following:
subfield(Concat(Classifier&'_'),'_',1) As Classifier_Concat
Resident PROJECTFILES where Classifier<>'NULL'
Group By ProjectType;
Thank you for your guidance