I am a PHD student and just finished data collection for my third study, which was a vignette study. I designed an online questionnaire with 30 different scenario's, or vignettes, followed by a block of 7 questions (the same questions after each vignette). Each participant was randomly exposed to 5 vignettes, out of the total of 30. The vignettes are composed of two variables: a topic (ranging from low to high in intimacy, 5 topics) and social tie (ranging from weak-strong, 6 ties). Thus, each vignette/scenario was composed of those two variables: 5 x 6 = 30 scenario's total. Now, I have no idea how to organize this data in SPSS. I just downloaded the data file from Qualtrics which is, obviously, largely empty because everyone participant only saw 5 scenario's. Hence there is a lot of 'missing data'. I'm assuming i have to somehow arrange the scenario's in a column, so the scenario then becomes the unit of analysis as opposed to the participant (this is what I'm used to). Any ideas on how to organize this data? I hope I have provided enough info! Thanks in advance!