skip empty database fields when printing address labels

My address database has the following fields:

  • Name
  • Address Part 1
  • Address Part 2
  • Address Part 3
  • City
  • State
  • Postcode

Not every database row has every Address Part and I do not want the printed label to have blank rows.