Duplicate address

hi frnds,

in vendor table i want to to extract duplicate addresses of customers.

Ex:

Address1 VendTable.Name

Address2 VendTable.Street+" "+ VendTable.City

Address3 VendTable.State +" “+ VendTable.Zipcode+” "+ VendTable.CountryRegiobId

plz help me to solve this, Thanks inadvance.

Rajesh.