Forum Discussion
Solved
Formatting the output of a SPILL - Is it possible?
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...
You can use TEXTJOIN to combine the result of your FILTER formula:
=TEXTJOIN(", ", TRUE, FILTER(...))
You can use TEXTJOIN to combine the result of your FILTER formula:
=TEXTJOIN(", ", TRUE, FILTER(...))
- Amazing. Thank you. This will be incredibly helpful.
