如何在Google表中垂直堆叠阵列？
我到处都在搜索，我以前找不到这个解决方案，因此，如果已经回答了，我深表歉意。
我目前正在以Google表格建立形式，以请求全名和死亡日期（出于宗教目的），并旨在改善用户体验，将该领域的格式化为长答案字段，并确保该人回答表单将用逗号分开名称和日期：
- [a-za-z]+\ s [0-9] {2}/[0-9] {2}/[0-9] {2} {2} $， *
当人发送响应时，它的格式是这样的 |全名和死亡日期| | - | | Maria da Silva 27/05/22，Juliana da Silva 26/05/22，Leonardo da Silva 28/05/21 |
我想取得这个结果，因此我可以在过去49天内对死者进行分类： |全名|死亡日期| | - | - | | Maria da Silva | 27/05/22 | | Juliana da Silva | 26/05/22 | | Leonardo da Silva | 28/05/21 |
当前，我正在使用以下公式来捕获单个单元格的信息
=TRANSPOSE(SPLIT(H6;", ";false))
，其中H6是我要转置的单元格的参考。
当我沿列拖动选择时，我会得到#REF！当结果重叠时出错。如何在没有此错误的情况下将结果堆叠在单列中？
Here is the table link and here is the Form link 。很抱歉，但目前仅在巴西葡萄牙语中，我计划将来还用英语和西班牙语创建新版本。
另外，我不知道是否可以，但是我想避免列表中的重复名称，因此，将来，我想创建一个像搜索字段或Google表单中的其他名称，当该人填充它以显示相似的结果或自动完成，如果该名称已经存在，则该名称的名称被排除在具有唯一函数的列表之外，或者表单不允许该人再次插入该名称。
提前致谢！
I've searched everywhere and I could't find this solution before, so I apologize if this was already answered.
I'm currently building a form in Google Forms to request Full Names and Death Dates (for religious purposes) and, aiming to improve User Experience, I'm formatting the field as a Long Answer field with the following regular expression to ensure the person answering the form will separate the names and dates with commas:
- [A-Za-z]+\s[0-9]{2}/[0-9]{2}/[0-9]{2}$,*
When the person send the response, it's formatted like this in a cell
|Full Name and Death Date|
|-|
|Maria da Silva 27/05/22, Juliana da Silva 26/05/22, Leonardo da Silva 28/05/21|
I want to have this result instead, so I can sort people deceased in the last 49 days only:
|Full Name|Death Date|
|-|-|
|Maria da Silva|27/05/22|
|Juliana da Silva|26/05/22|
|Leonardo da Silva|28/05/21|
Currently, I'm using the following formula to capture the information of a single cell
=TRANSPOSE(SPLIT(H6;", ";false))
Where H6 is the reference of the cell I want to transpose.
When I drag down the selection along the column, I get the #REF! error when the results overlap. How can I stack the results in a single column without having this error?
Here is the table link and here is the Form link. I'm sorry, but it's currently in Brazilian Portuguese only, I plan to create new versions in English and Spanish as well in the future.
Also, I don't know if that's possible, but I want to avoid repeated names in the list, so, in the future, I want to create like a search field or something in Google Forms when the person is filling it to show similar results or autocomplete if that name already exists so either the name is excluded from list with a Unique function or the form doesn't let the person insert that name again.
Thanks in advance!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
使用：
或：
use:
or: