Hi, i am using formula
"=LET(b;FILTER(A7:A29003;A7:A29003<>"");c;FILTER(B7:B29003;B7:B29003<>"");BYROW(CHOOSE(SEQUENCE(;7);A4;c;B4;D2;C4;b;D4;LAMBDA(br;CONCAT(br))))"
to fill with data from others cell. I am interesting is it possible to automatic delete data from column A (A7 - A29003) and column B (B7 - B29003) "=LET(b;FILTER(A7:A29003;A7:A29003<>"");c;FILTER(B7:B29003;B7:B29003".
thanks in advance
"=LET(b;FILTER(A7:A29003;A7:A29003<>"");c;FILTER(B7:B29003;B7:B29003<>"");BYROW(CHOOSE(SEQUENCE(;7);A4;c;B4;D2;C4;b;D4;LAMBDA(br;CONCAT(br))))"
to fill with data from others cell. I am interesting is it possible to automatic delete data from column A (A7 - A29003) and column B (B7 - B29003) "=LET(b;FILTER(A7:A29003;A7:A29003<>"");c;FILTER(B7:B29003;B7:B29003".
thanks in advance