Collate and Index Info

I have tried looking at the first problem - collating all criteria from multiple cells into a single cell. I have turned the 'Y" references into the values to match the corresponding criteria/column it falls under. Then I have applied the TRIM formula to collate the results.



However, I still need to collate the results (entries) into their designated units AND I need the reference to come back as text "Y"!!???

Have attached updated example FYI.


Thanks again :-)