http://www.exceldashboardtemplates.com/the-best-way-to-separate-address-text-to-multiple-columns/ http://www.exceldashboardtemplates.com/how-to-convert-an-existing-excel-data-set-to-a-pivot-table-format/