交叉连接两列 [英] Cross Join two Columns

问题描述

我想将Google表格中的这两个列联接在一起，以便将A列的每个单元格都联接到B列的所有值.谢谢

I want to Join these two Columns in Google sheets so that each cell of column A is Joined to all the values of Column B. Thanks

标签日期

Ess Performance        7/1/2019

DV3-Retargeting         7/2/2019

Facebook WCA            7/3/2019

DV3-Retargeting          7/4/2019

DV3-Retargeting          7/5/2019

DV3-Retargeting          7/6/2019

DV3-Retargeting          7/7/2019

Facebook LAL            7/8/2019

DV3-Retargeting         7/9/2019

FiddeAds            7/10/2019

                    7/11/2019
                    7/12/2019
                    7/13/2019
                    7/14/2019
                    7/15/2019
                    7/16/2019
                    7/17/2019
                    7/18/2019
                    7/19/2019
                   7/20/2019
                    7/21/2019
                     7/22/2019
                      7/23/2019
                      7/24/2019
                      7/25/2019
                      7/26/2019
                     7/27/2019
                       7/28/2019
                     7/29/2019
                     7/30/2019
                     7/31/2019

我想看的输出

Ess Performance         07-01-2019

DV3-Retargeting     07-01-2019

Facebook WCA            07-01-2019

DV3-Retargeting         07-01-2019

DV3-Retargeting         07-01-2019

DV3-Retargeting         07-01-2019

DV3-Retargeting         07-01-2019

Facebook LAL            07-01-2019

DV3-Retargeting         07-01-2019

FinddAds            07-01-2019

等等.....

推荐答案

不确定我是否完全理解您要实现的目标，但是看是否有帮助

Not sure if I fully understood what you try to achieve, but see if this helps

=ArrayFormula(split(substitute(transpose(split(join(" ", query(split(join(char(10), filter(substitute(C2:C, " ", "|"), len(D2:D))&char(10)), char(10))&"_"&text(filter(D2:D, len(D2:D)), "yyyy-mm-dd"),,9^9)), " ")), "|"," "), "_"))

这篇关于交叉连接两列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！