I’ve seen this format from other tickets as well, but don’t know if they were using Qualtrics. Instead of having a best/worst variable for each question in the maxdiff study per data setup here: [https://wiki.q-researchsoftware.com/wiki/Marketing_-_MaxDiff_-_Hierarchical_Bayes|https://wiki.q-researchsoftware.com/wiki/Marketing_-_MaxDiff_-_Hierarchical_Bayes|smart-link] . Customers sometimes get data where the respondent data is setup as a Pick One-Multi for each question (each option is a variable) with the codes indicating what was chosen as best/worst. - see screenshot below. It’s a pain to get this into the correct format in Q and would be great if it could be automated.

!image-20220517-030446.png|width=1952,height=810!