Project Description:
Need a list created in Excel of all pubs in Australia showing with data valid from November 2012. Each row should be a record with all of the following represented separately. Results will be audited.
* Pub name
* ABN
* Street address (broken into the following columns street address / City / Postcode / State)
* Phone number
* Website
* Email Address
* Licensee Name
* Licensee Email
Each of the fields represented by * needs to be a separate column (and even more so for street address). It is to be imported into CRM so needs to be ready for csv format.