Formatting the output of a SPILL - Is it possible?

[mtwelve]

I've written a FILTER formula to retrieve values from a table.

There is more than one results so I am receiving it as a SPILL.

Is it possible to return all the values to show in a single cell?

Can you adjust the format of the SPILL output in that single cell?

I'd like to create a delimited list (ideally CSV) of all the results and for them to be returned to a single cell.

[#2 · Accepted solution]

@mtwelve 

You can use TEXTJOIN to combine the result of your FILTER formula:

=TEXTJOIN(", ", TRUE, FILTER(...))

[#3]

Amazing. Thank you. This will be incredibly helpful.