Working on a fair registration but the results are almost useless because of the use loop and merge

That's just the way it is with Qualtrics, for better or worse. We use Loop & Merge in a few projects, and our data analysts have to download the data and transform it in Excel, SAS, or another tool to stack the L&M columns.

Your issue isn't specific to loop & merge. Qualtrics always records data as 1 row per response. So whether you used loop & merge or separate questions you would have the same issue. There are a couple of different solutions:

1. Normalize the data after the fact. Basically repeat (or automate) the process you used to for "How I want it to look"


2. Separate into two different surveys - one to collect the respondent info and a second to collect the info for each registration. The second survey can be repeated multiple times. It is fairly tricky to set up. In the first survey you would create a contact with respondent info and redirect to the second survey. The second survey would use an authenticator with automatic authentication to bring in the respondent info. At the end you would have a "enter another registration" question. If yes, you would redirect back to the second survey again.

TomG I forgot I was talking about excel because my mind always goes to the word reporting to achieve the desired look. However, this user prefers Excel. I told her we could hard code the workflow she receives on a daily basis to achieve the desired look, but she wants excel so she can sort multiple ways.