Eliminating null values from a view

Hi,

Is there any way to eliminate null values from a view and shrink the view to consist of only non-null values.

For example, I have a view with 3 columns which looks like as shown below -

  Col1             Col2              Col3

 _____          _____           _____

 value1          <null>           <null>

 value2          <null>           <null>

 <null>            value3          <null>

 <null>            value4          <null>

 <null>            <null>           value5

 <null.              <null>          value6

After removing the null values, the view should look like this -

Col1             Col2                Col3

 _____          _____           _____

 value1          value3          value5

 value2          value4          value6

Is this possible or even partially possible?

Thanks in advance.

Regards,

Kaustav Dasgupta