Hi Rahul ,
Thank you for responding .
I didn’t get your question regarding the color attributes.
I wanted to do a lookup on the group attributes from table 1 with Audit group in table 2 and afterward transpose the attributes corresponding to the Audit Group (Orange , Apple etc) as the headers.
Suggestions are welcome on how to proceed . 