What you are attempting to do is not possible unless you have it computed within the document. At the view level, you cannot dynamically change the column display based on a related column.
Here is one article that I did long time back
Again the above solution would work only if you displaying it as categorized or multi-value fields.
Field A= Open
Field B= Executive
Field C= GNS
Create a new field AB and CD (multivalue)
Field AB:=A:B (Now holds the values Open, Executive)
Field CD:=C:D (Now holds values from C &D GNS, RoR)
AB+"\\"+CD (Will now hold Open\\GNS and Executive\\RoR) NOTE: Search Domino article did not have the \\ as that was removed by the website during upload
If you need them to display in a normal column, remove the \\ and in the view show multiple values as separate rows and use the categories field.