Not 100% sure what you mean by "The table is present at the 4th row in excel , so can't able to use Column scenario." so will give advice on both options.
If it is just your table starts on 4th row that should not be issue, just get the range and you can reference in the Add Criteria to Autofilter.
Then for filtering out values you can use "<>value" so it filters out that value. If you use case is you want to filter out 0s and blanks (and your data is numbers) then the following should work.
Criteria with value of "<>0" filters out not equal to 0, Operator value of 1 is AND for Criteria2 value of "<>" filters out blanks.
If your data is not numbers and you want to filter out multiple text values like " 0" and " 0.00" I don't think the VBO offers something to do that so ideally would see about getting data formatted.
However if what you are saying is your data is a horizontal table then your best bet is to just find a way to transpose the data to get it into a standard vertical table so then you can use standard filter methods. I don't think excel VBO offers this even though you can copy and paste as transpose in excel. You could maybe load in to a collection then use collection VBO to transpose, not sure if it would work with the data.
