Formatting the output of a SPILL - Is it possible?

New Contributor

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 Replies
best response confirmed by mtwelve (New Contributor)


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



Amazing. Thank you. This will be incredibly helpful.