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.
我有一个收集回复的Google表单,数据存储在Google Sheets文档中。我希望在不更改Google表单中输入字段的顺序和排列的情况下,重新组织和合并响应表中的数据。
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.
具体地说,我希望在不影响表单的字段顺序的情况下将数据从一列(F列)移动到另一列(B列)。这意味着先前收集的数据和该字段的未来响应都应该存储在列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.
我尝试手动移动列,但问题是其余数据仍然存储在列F中,而不是列B中。
What's the most efficient way to achieve this data reorganization in Google Sheets, ensuring that the form's field order remains intact?
在Google Sheet中实现这种数据重组、确保表单的字段顺序保持不变的最有效方法是什么?
I appreciate any insights or suggestions on how to approach this task. Thank you!
我感谢任何关于如何处理这项任务的见解或建议。谢谢!
更多回答
your sample has no data in column F. so either add sample data to match your description of the problem, or modify your description to suit the data.
您的样本在列F中没有数据。因此,请添加样本数据以匹配您对问题的描述,或修改您的描述以适应数据。
@MrShane Sorry. I fixed it.
@谢恩先生,对不起。我把它修好了。
优秀答案推荐
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.
只有一个配方。
更多回答
Thanks. It is a good idea, but I am looking for a direct idea in order to be done on the main response sheet instead of creating another sheet.
谢谢。这是一个好主意,但我正在寻找一个直接的想法,以便在主响应表上完成,而不是创建另一个表。
Cannot be done. Not unless one uses scripts. But in any case, It is a bad idea messing with the original sheet. FWI. When one says "new sheet", it means "new tab" (as you already have in your answer sheet).
这是不可能做到的。除非使用脚本,否则不会。但在任何情况下,扰乱原始表格都是一个坏主意。第一次世界大战。当一个人说“新纸”时,它的意思是“新标签”(就像你在答题纸上已经做过的那样)。
No, the new sheet was created by one of the other users who was working on the shared sheet :)
不是,新工作表是由正在处理共享工作表的其他用户之一创建的:)
我是一名优秀的程序员,十分优秀!