Reorder columns from Form results

Copper Contributor

I'm after some help. I've seen several of these posts but the solutions either never work or aren't possible so here goes. 

 

I have created a form in Microsoft Teams using the Forms app. The form has several questions but some were created out of order. When I go to view the responses the data is shown in the order the questions were created in.
- I have tried dragging the columns but this results in the moved headers no longer pulling data through. - I have tried syncing to a new spreadsheet but this doesn't work (might be my company settings but it never saves to anywhere. 

 

All I want to do is move the columns so that the data follows the order the questions are asked in. Never had any issues like this when using Google sheets. Surely it can't be hard to sort?

0 Replies