I probably did not phrase my question accurately. Is there a way to remove the result 'a' because it fulfils the '<>1' condition? I am pretty sure a mixture of query and arrayformula is needed but I can't figure it out.
Also - I am aware I can split it into multiple columns to achieve what I want but I am looking for a solution that requires only 1 formula.
Any suggestions would greatly help!