Google Form and Google Sheet data order problem
I want to use Google Forms to enter data but need that data to come out on a Google Sheet in a different. For instance: I enter data in numerical sequence 1-10, but on the Sheet, it needs to appear in a different order.
How can I achieve that?
Background: right now data is entered into Forms the exact way it needs to appear on the Sheet.
What I'm doing now:
I am entering the data into forms in this order:
D
A
B
C
So that Sheets outputs:
D
A
B
C
OK. It works, but it's time consuming since it forces me to jump around looking for the data to input into Forms in Order.
What I want to do:
Enter data into Google Forms in this order:
A
B
C
D
So that Sheets outputs:
D
A
B
C
If this makes sense, how can I make Google Forms and Google Sheets work together to take my input the way it's in order as it is received (real life to me to Google Forms), and output in the proper order (Google Forms to Google Sheets in proper spreadsheet order)?
Thanks guys.