Best way to recode data clearly into experimental conditions?

Hi there,

I have exported some data from qualtrics for an experimental study (data is survey responses).

Participants see 1 of 6 case vignettes. I manipulate child age (13,15,17) and gender (male, female) so it is a 3x2 design. These are presented randomly, and I go on to ask various questions like "did 13 year old female commit a crime?" so this has resulted in lots of columns!

Qualitrics doesn't track the experimental condition for me, so the only way I can see which condition the participant saw is to scroll right now. I started running descriptives but I realised I need to create a 'child gender' and 'child age' variable.

What is the best way to go about this? I have attached a shot of what the sheet looks like.

Thank you in advance!