Do you have any identifier that tells you if it is a Home Address or Word Address?
If so then write CASE Statements in all the columns to pick only the home address in the Home Address column and Work Address in the work address column.
See if this helps..
Try union query, one displaying the home address and the other displaying work address. Then pivot the view to flatten it out.