excel formula to filter values from an array

[Monicasinha]

I have data in row and column. I need to filter the data with certain condition. The result should come in single column.
When I use filter formula, it gives results in an array but I need it in a column

I have uploaded image of how my data is arranged and how I want to see the result. Can you pls help.

 

[awoohaw]

Try this:

=FILTER(TOCOL(A1:K17),TOCOL(A1:K17)>0,"")

 

[Georgiboy]

Another option without FILTER:

=TEXTSPLIT(TEXTJOIN(",",TRUE,A1:E17),,",")

Ignore me, should have looked at what you wrote about "filter the data with certain condition"

 

[Monicasinha]

Try this:

=FILTER(TOCOL(A1:K17),TOCOL(A1:K17)>0,"")

Thank you so much! This worked! Awesome

 

[awoohaw]

Thank you so much! This worked! Awesome

Happy to help.
Best Wishes!

 

[Fluff]

Bit late, but another option

=TOCOL(IF(A1:K17="",x,A1:K17),2)

 

[Monicasinha]

Thanks Fluff!

 

[Fluff]

You're welcome & thanks for the feedback.