How can I move and consolidate data in a Google Form responses sheet without altering the form's field order?

Question

I have a Google Form that collects responses, and the data is stored in a Google Sheets document. I want to reorganize and consolidate the data in the responses sheet without changing the order and arrangement of the input fields in the Google Form.

Specifically, I want to move data from one column (column F) to another column (column B) without affecting the form's field order. This means that both the previously collected data and the future responses for that field should be stored in column B.

I have tried manually moving the column, but the issue is that the rest of the data is still stored in column F instead of column B.

What's the most efficient way to achieve this data reorganization in Google Sheets, ensuring that the form's field order remains intact?

I appreciate any insights or suggestions on how to approach this task. Thank you!

Answer 1

In a new sheet try:

={'Form Responses 1'!A:A,'Form Responses 1'!C:F}

OR even:

={'Form Responses 1'!A:A,'Form Responses 1'!F:F,'Form Responses 1'!C:E}

One single formula.