I have a 30k line address list that looks like this:
Customer #1
ATTN: ACCOUNTS PAYABLE
Street Address, SUITE B
CITY, STATE
ZIP CODE
Customer #2
Street Address
City, State
ATTN: ACCOUNTS PAYABLE
Zip Code

I need to move all the information from one column to 5 (transpose the info
so that all the names are in one column, cities in another, etc.). Does
anyone know how I can do that without copying and pasting each address?