We have a mail list of about 2500 addresses that is in a single column with blank lines as shown below. We need to convert this list into at least 5 separate columns for name, address, city, state, and zip so that our mailing software can work with the list. The city, state and zip information occupies a single cell. Any ideas on the best way to do this?
blank line
name 1
blank line
address 1
city state zip
blank line
blank line
name 2
blank line
address 2
city state zip
blank line
blank line
name 1
blank line
address 1
city state zip
blank line
blank line
name 2
blank line
address 2
city state zip
blank line