时间戳

首页 > 解决方案 > 交叉连接两列

google-sheets - 交叉连接两列

问题描述

请在此处查看图片

我想在 Google 工作表中加入这两列，以便将 A 列的每个单元格加入到 B 列的所有值。谢谢

标签日期

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

很快...........

标签： google-sheetsgoogle-sheets-formula

解决方案

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

=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)), " ")), "|"," "), "_"))

推荐阅读