ConcatRows

ConcatRows.txt

/** ConcatRows */
/*
    FUNCTION NAME: ConcatRows
    DESCRIPTION: For a rectangular array (including table refs), returns
        a dynamic array 1 column wide and n rows tall, concatenating the
        values from each row
    ARGS:
        rng: The source range to be concatenated
        delim: The delimiter to be used
        skipblanks: In each row's concatenation, TRUE skips blank 
            values and FALSE includes blank values

    EXAMPLE: 
        =ConcatRows(MyTable[#All],"|",FALSE)
*/
ConcatRows = LAMBDA(
    rng,
    delim,
    skipblanks,
    BYROW(
        rng,
        LAMBDA(
            r,
            TEXTJOIN(delim,skipblanks,r)
        )
    )
)