How do I write the formula so that all x,y coordinates are display without spaces using a FILTER???

[arthurz11]

How

 

[SunnyAlv]

from the looks of it, it just combines all the x,y tables

 

[arthurz11]

from the looks of it, it just combines all the x,y tables

The process that I am doing is that I first filter the data vertically. Now I need to filter the data horizontally. The ranges are very, very long. But just knowing how to write the filter horizontally will facilate my results. The actual range that I am doing is from WY11 to BLN11. So as you can see, that'a a very, very long range. So instead of copy and paste, the FILTER formula would be much simplier. Would you please be so kind as to let me know what do I write after =FILTER(A2:H2,A2:H2 so I can get the results like rolls A11, A12, and A13?

 

[Peter_SSs]

Not much to go on but try

=FILTER(A2:H4,A1:H1<>"")

 

[SunnyAlv]

Like this ?

=FILTER(A2:H4,(A2:H2<>"")*(A3:H3<>"")*(A4:H4<>""),"")

 

[arthurz11]

Not much to go on but try

=FILTER(A2:H4,A1:H1<>"")

Thank you soooooo much. Works perfectly!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.