Hi All,

I have a raw data set that contains 4 columns of data, some with blanks,
some without. What formula will allow me to extract only nonblank cells,
skipping the blanks. So instead of having a list of 500 rows with tons of
blanks, I want to list - on a separate tab - 50 rows of nonblanks. I can't
use pivot tables because I need more functionality, and can't use autofilter
because for any one row - i may have a blank in the first column but a dollar
amount in the next. I prefer not to collapse the source data - I want to let
that come in just as it is since it's external query. My lookup formula will
reside on a different tab. Help :)

If I didn't explain it clearly, please let me know...thanks so much :)