Hello,
I was given a file to clean up. It has over 15,000 address entries in a row format:
<tbody>
ID
Agency
201
Name
Address 1
City,State, Zip
Phone #
</tbody>
There is an id number assigned in the cell in column A at the Agency name. All the address fields start in column...