Power Query Conditional Column with "Else If" is returning ()blanks

I am not sure that is feasible. It is a monstrous file (almost maxes out the 17000 column limit) and I don't know if sample data would be able to replicate the issue. But a few more details about the data that seem to be important in some way:

1. The HACORF cases that seem to be not sorting correctly for the CLASS condition all do have multiple rows of data in the dataset with a primary row containing all the variables used in my conditions and secondary(+) rows containing values for a very limited amount of variables (~20 or less) unrelated to any conditional coding. I tried a "de-duplicate" step to remove any secondary(+) rows since that data is not relevant at the moment but that did not affect the table showing the count of observations still "blank" for the CLASS variable.

2. However some of the HORF cases also have instances of multiple rows for an observation but they all did sort correctly by CLASS.

3. Some of the HACORF blanks should be CLASS=CO (ie. they are not all just CLASS=PENDING) but also seem to be an observation that has multiple rows.

4. No matter what combination of other variables I tried that should respond to resorting for the CLASS condition there is something unique about these observations and their unwillingness to be labeled.