( by Ivar Gosman )
Suppose we have the following data in our 'Sheet3' of the spreadsheet.
Now to get the data as per your requirement you need to use Query function instead of a Filter function.
Put the following formula in some other sheet of the same spreadsheet:
=query(Sheet3!A2:Q20;"select A,B,C,D,E,F,G,H,Q where Q<>'' ")
So, you can see the output in the above Sheet, we are fetching data from Column A to Column I and then from Column Q.
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.