JOINARRAY() function Idea

L_123

=JOINARRAY([End Delimiter],Range 1, [Range 1 Delimiter],...) *No delimiter for last range listed.

=JOINARRAY(", ", A:A, " ", B:B)

results in:

x 1, y 2, z 3

blank values are ignored, hence the over-ride for the end of the item delimiter

L_123

@Paul Newcome

Curious about your thoughts on this one.

Paul Newcome

@L_123 I've seen this pop up quite a few times, and we always have to use a helper column in the source sheet to first join columns A and B together then bring everything over to the target sheet from the helper column.

L_123

@Paul Newcome Yes, it's solve-able with a helper, which is what i've had to do historically (sometimes multiple helpers)

I think modifiable arrays would be amazing, and this could just be the first step. imagine if you could modify a range with a collect formula prior to using the criteria, that would be another example that could be huge.

Added the collect idea :https://community.smartsheet.com/discussion/109279/collectmod-formula/p1?new=1