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 there is a ton of data
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!!!
Bookmarks