=SPLIT(ПОВТОР(JOIN(",";ТРАНСП(FLATTEN(SEQUENCE(B4;1;1;0);SEQUENCE(C4;1;0;0))));D4);",")=SPLIT(ПОВТОР(JOIN(",";ТРАНСП(FLATTEN(SEQUENCE(B4;1;1;0);SEQUENCE(C4;1;0;0);{""})));D4);",")
I1:I2:=
{
{
"Месяц"
;" "
;ArrayFormula(
IF(
H3:H10<>""
;TEXT(H3:H10;"mmm")
;
)
)
}
\
{
"Год"
;" "
;ArrayFormula(
IF(
H3:H10=""
;
;TEXT(H3;"YYYY")
)
)
}
}={{"Месяц";" ";ArrayFormula(IF(H3:H10<>"";TEXT(H3:H10;"mmm");))}\{"Год";" ";ArrayFormula(IF(H3:H10="";;TEXT(H3;"YYYY")))}}={
"Наши ссылки"
;ARRAYFORMULA(
"https://....product/mod"
&SEQUENCE(100)
&"/"
)
}https://cdn-images.farfetch-contents.com/https://skdreplic.com/images/
=TO_DATE(LEFT("2022-11-13 18:23:15.0";LEN("2022-11-13 18:23:15.0")-2))=TO_DATE(REGEXREPLACE("2022-11-13 18:23:15.0";"((\d{4})-(\d{2})-(\d{2})).*";"$4.$3.$2"))...WHERE Col1 = 'name'";0)