Sorry for the title, I know it might be pretty wide and not so much informative. I am facing a problem regarding the analysis of a data set. The participants of my experiments were randomly assigned to different conditions and some stimuli were randomly assigned to them. I would like to analyse the data (without looking each line one by one) but I don’t know how to do because of the randomly assigned stimuli. Can you please tell me how to do it ?

The table (please, don’t give attention to the yellow cells):

enter image

As you can see, each stimulus (x_.jpeg) is associated with a binary answer. I would like to reproduce it in the right side of the table in order to have a detail of the answer of each participant facing a specific stimulus.

Thank you in advance 😉 !