Concatenate merged cells in Google sheet

huangapple go评论77阅读模式
英文:

Concatenate merged cells in Google sheet

问题

我在Google表格中遇到了这个情况。

我想要将第1行和第2行连接起来,生成一个数据验证列表,以便在另一个选项卡中用作下拉菜单。连接的结果应该像期望的结果那样。我无法找到一个适用的公式。请帮忙。我已经添加了一个示例表格的链接。
https://docs.google.com/spreadsheets/d/1m572P3bvLe3l8fpXRrL0MceW-lrVIBLcgHXO4jOAJnc/edit?usp=sharing

英文:

I have this situation in google sheets.
Concatenate merged cells in Google sheet

I want to concatenate Row 1 and Row 2 to generate a data validation list to be used as a dropdown in another tab. The concatenate result should like Expected Results. I am not able to figure out a formula for this. Please help. I've added a link to the sample sheet.
https://docs.google.com/spreadsheets/d/1m572P3bvLe3l8fpXRrL0MceW-lrVIBLcgHXO4jOAJnc/edit?usp=sharing

答案1

得分: 0

<!-- language-all: js -->

你可以尝试使用以下公式:

=index(scan(,B1:1,lambda(a,c,if(c=&quot;&quot;,a,c)))&amp;&quot;-&quot;&amp;B2:2)

Concatenate merged cells in Google sheet

英文:

<!-- language-all: js -->

You may try:

=index(scan(,B1:1,lambda(a,c,if(c=&quot;&quot;,a,c)))&amp;&quot;-&quot;&amp;B2:2)

Concatenate merged cells in Google sheet

huangapple
  • 本文由 发表于 2023年7月27日 15:57:56
  • 转载请务必保留本文链接:https://go.coder-hub.com/76777623.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定