Help with address formatting from wordpad to make a mailing list

**jdanderson19** · 03-11-2013, 11:24 AM

Hey everyone,
I have a data set for over 9000 addresses and can't get it formatted the way I need to. Attached is a small version of the doc. I need colums with "Name, address, zip, state, etc." and need to get rid of any duplicate addresses.
address mock1.xlsx.

The main issue i'm running into is some of the addresses are 3 rows, some are 4 or 5. If there is a way to group all the data automatically between the "----------------------" that seperate them I think the offset or concatenate tools might work?

This document was originally wordpad in this form and I don't neccesarily need all the data, mainly need to make a mailing list.
address mock1.txt

Thanks!

**FDibbins** · 03-11-2013, 11:31 AM

Hi and welcome to the forum

We would love to help you with your question, but 1st, please rename your thread to something more meaningful, that actually describes your problem. Many members will look at a thread title, and if it is of interest to them, or falls within their area of expertise, they might only open those threads. also, searching for "help" will not turn up too many results that will benefit you, sorry.

Look at it this way...if you typed that title into google, what would you expect to get back?
To change a Title on your post, click EDIT on you're 1st post, then Go Advanced and change your title