I have a list of taxpayers in a county and I am trying to break it up
into a list of Names and Addresses.

There is a lot of erroneous data included on the list and it is not an
excel file or any other recognizeable format.

When i import the data into excel, everything is put into a separate
cell. It looks something like this: Each line would be in a separate
cell... but all in one column

A
1===========================
2Account: 000151270003
3Owner: A 4 HOME CENTER
4
5PO BOX 757
6Market Value: 250,190
7ROBBINSVILLE NC 28771
8
9Tax Description Asses
10__________________ _____
11COUNTY WIDE 250,
12
13===========================
(this goes to row 65600 or something ridiculous)

(Hope this is making sense thus far)

Now i need to somehow separate this into a useable data base for
instance, column A is name, column B is address etc.


I guess i need each of the 13 rows above put into their own individual
columns? Then i can delete the ones i dont need.
I tried a paste - transpose which works fine for one block. But i have
like 65,000 of these 13 row blocks.


If anyone thinks they could help me out on this matter i would REALLY
appreciate it. We are starting a food bank for a small mountain town
in North Carolina so your effort is going to a good cause! If anyone
would like to take a look at the raw data file or the excel data i have
thus far i wouldnt have a problem emailing it to you. Its public record
so its not like there are any confidentiality issues.

Thanks so much!!!


--
usf97j4x4
------------------------------------------------------------------------
usf97j4x4's Profile: http://www.excelforum.com/member.php...o&userid=30361
View this thread: http://www.excelforum.com/showthread...hreadid=500160