Suppress a field when no data available

Hi,

How can I suppress a field when no data available
that is when no data or null then the
should not be displayed only but also the other row
will one row upward.For axample the fields are:

row1--- <<Contact Name>>
row2--- <<Company Name>>
row3--- <<Street Address>>,
row4--- <<City Name>> <<Zip Code>>,
row5--- <<State>>, <<Country Name>>

When no data in Database for <<Company Name>> and <<State>>

it should show like

row1--- <<Contact Name>>
row2--- <<Street Address>>,
row3--- <<City Name>> <<Zip Code>>,
row4--- <<Country Name>>

My query returns null---->

row1--- <<Contact Name>>
row2--- null
row3--- <<Street Address>>,
row4--- <<City Name>> <<Zip Code>>,
row5--- null, <<Country Name>>

How can i solve this?

Any help appriciated

Alauddin