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?
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.
You can use TEXTJOIN to combine the result of your FILTER formula:
=TEXTJOIN(", ", TRUE, FILTER(...))
2 Replies
You can use TEXTJOIN to combine the result of your FILTER formula:
=TEXTJOIN(", ", TRUE, FILTER(...))
- Amazing. Thank you. This will be incredibly helpful.
