For categories with more than one secondary question, the export report combines them into one row. You can now separate the secondary questions in the report to make them easier to read.
Instructions
Sign in to your site if you have not done so already
Navigate to the Requests tab:
Navigate to the Categories field and select one category to view:
Select the Export Requests tab:
Select Confirm:
Select Excel format (.XLSX), then click Continue:
Within the Excel spreadsheet, select Find & Select, then choose Replace:
Search "Q:" and replace it with ":" then click Replace All:
Search "A:" and replace it with ":" and then click Replace All:
Highlight the Secondary Questions column (row R):
Select the Data tab:
Click Text to Columns:
Select the Delimited option, then click Next:
Select the "Other" option under Delimiter and enter ":" in the blank space, then click Next:
Note:
This will write over any columns to the right of the column you are working in, so be sure you are okay with that data being cleared. If not, move the Column to the last column to the right so it's all blank fields that it writes over.
Click Finish:
