Book2.xlsxI have a PDF Document that I converted to Excel. The Document is a list of addresses. I need to convert these rows into columns...
Example:
ABC WHOLESALE
Joe Smith
123 Elm Street
City, State, zip
PHone
Fax
web address
contact
contact
contact
etc.. etc.
There are 2,569 Lines with rows seperating the next address
I need to convert to the following format:
Column A Column B C D E F G H I J
Company Address City State Zip Phone Fax Web Address Contact Title
ABC CO 123 ELM Mulberry CA 12335 555-1212 555-1212 uknown Joe Smith President
Can someone help me with this. I am not familiar with writing codes. I am familiar with Excel 2010. I would prefer to not have to go through each line. Thanks, Jen
Bookmarks