Matrix Likert Table Script

tobyhkim Could you explain a little more about what you want the end result to be? If you're exporting the answer choices to Excel, I'm unsure what you're working towards with linebreaks/commas.

Hi jmborzick,
Thank you for your help! So if I have the following question:
and someone selects "Scale Point 1" for "Statement 1", "Statement 2", and "Statement 3" I would want the workflow to give me a row in Excel that looks like this:

tobyhkim I understand now. I'm sorry, but my best solution is to export the data to Excel in one tab that will be used only for the export. I'd then use formulas on a secondary tab to reformat everything into the appropriate format. This would include concatenating the three columns into one cell with the line breaks (char(10)).

jmborzick
I see... Is there a way to at least get each data point into three different columns? I'm struggling even with that aspect. So three columns, "sampleOne", "sampleTwo", and "sampleThree" and the rows respectively would show "Statement 1", "Statement 2", "Statement 3".

tobyhkim
Why don't you use 3 embedded data with these values and you will get it in 3 columns. Include this after the questions block.

${q://QID13/ChoiceGroup/SelectedChoicesForAnswer/1}

${q://QID13/ChoiceGroup/SelectedChoicesForAnswer/2}

${q://QID13/ChoiceGroup/SelectedChoicesForAnswer/3}

tobyhkim When you're mapping the fields to your spreadsheet, you'll want to scroll down to the bottom and choose the fields corresponding to your rows (see screenshots)

Deepak And there isn't a way to manipulate the embedded data to return an array like jmborzick is saying, correct?
${q://QID13/ChoiceGroup/SelectedChoicesForAnswer/1/1}
${q://QID13/ChoiceGroup/SelectedChoicesForAnswer/1/2}
${q://QID13/ChoiceGroup/SelectedChoicesForAnswer/1/3}
for example

tobyhkim
No within Qualtrics if you want it concatenate include the three values in a embedded data comma separated and make it as text set it will allow you to view it on dashboard as each entity differently and within export as comma separated entity.
Hope it helps