Need help with merging data files into spreadsheet. Fields come in out of order. Any advice?

[KACCAK]

I have created a form (survey) in LiveCycle Designer. When using Acrobat Pro 9 (Forms ==> Manage Form Data ==> Merge Data Files into Spreadsheet), the data comes in accurately, but in the wrong order. For example, I have several sets of questions, and the data will come in random order (column 1 may be question 1, column 2 is question 4, column 3 is question 6, etc. I am creating a report from the data, and it would be so much easier if the column data was in the correct order.

Thank you.

[Former Community Member]

I believe that the hierarchy view will determine the order .....Can you reorder your hierarchy view to get the structure you want for your data?

Paul