Question sequence gets disordered when export a survey with Rating Scale questions to Excel sheet.

Issue:
Question sequence is disordered when we export a survey list to excel
Resolution – Only to get questions in proper sequence in Excel sheet!!

• Checked Survey settings
• Found there were total 50 questions and found almost 30 questions were created using "Rating Scale" category
• Changed question ordering from Survey settings > Change order of questions
• Previously it was from Q-1 > Q-1-a….Q-5 > Q-5-e
• Changed it to reverse order and arranged Q-5-e > Q-5…..Q-1-a > Q-1
• Exported to spreadsheet, and got all the questions in right order.
• Now another issue occurred, Q-6 (Multiple Line of Text) came first in datasheet, so from view removed it to be displayed or to be exported to spreadsheet.
• The other issue noticed was when user clicks on "Respond to this survey", user will get the same reverse orders of questions (i.e. Q-5, 4, 3, 2, 1, 6)
• Though this helps us to get questions in proper sequence only in Spreadsheet but this cannot be implemented as this occurs disordering of questions in survey.

Found 2 alternate workarounds
Workaround 1

• Changed all "Rating Scale" questions to "Choice" category with "Radio button" & fill in "mandatory" option
  
• Order remained same (i.e. Q- 1, 2, 3, 4, 5, 6)
• Now it worked proper for both scenarios, user got the right order when open "Respond to this survey" and also got the right order when exported to excel.

Workaround 2

• Created a page and added a Data View Web part using SPD on the page
• Used SharePoint survey as a Data source and added all questions / columns in to the web part
• Then from Data view web part exported data to excel

Feel free to reach me in case of any queries on above steps. Thanks