I have a list of locations in Excel. They are in once column and include name and address. I need to reformat this list into 4 columns (name, address, city, zip).
Am attaching a screen shot showing how I want the data to be reformatted in Excel. There are 2400 records.