0

I have a sheet that I am using the filter formula to find and display multiple values. This works great for displaying the results in a vertical column, where the values are pasted down in the column below the formula.

However, I would like to display the results in a comma separated list in one cell (or alternatively, pasted horizontally). Is there an alternate formula I should be using, or some formula to transpose the vertical results?

2

If it's just a single column of results, you could use JOIN:

=JOIN(",",FILTER(...))

Alternatively, You could also use

=TRANSPOSE(FILTER(...))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.