Need help with Formatting from PDF

[JohnSim22]

Hey everyone!

I am looking for help in formatting this file from the Town of Oyster Bay assessment roll. What I am trying to do is get my file to be formatted into an easy template so I can make mailers to be sent out. I need the Name of the owner, street address, town and value in columns next to each other. Now I was able to put it into a kind of acceptable way but it just gets a little hairy at some points. I was hoping that you guys would be able to help out in ways to get it into an more user friendly format. Some of the issues i am having is combining 3 cells into one and not losing any data when doing it. Anyway see attached for the file and thank you in advanced to anyone that is willing to help! I am an advanced Excel user but am curious to see someone else's brain would work it out.

Thank you!
John

[arlu1201]

Hello JohnSim22,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.

[Kaper]

Hi,

As you may be read description of this sub-forum - this one is solely to introduce yourself.

So here I'd say: welcome to the forum. And that's it.

With your merit question, please go to appropriate sub-forum. Look what sub-forums we have: http://www.excelforum.com/microsoft-...el-help-forum/ and post a new thread in one of them (the most appropriate one).