Hello friendly excel people 
I've been scratching my head all day with this issue and it's really getting to me. I have a PDF doc containing a list of; suburbs/cities along with their postal code and state, organised in 7 columns across 35 pages on an A4 page.
What I'm trying to do, is to copy/import all this data into an excel worksheet, with each PDF line copied into a separate excel row.
This is an example of how I'd love the data to look like in excel. I've also put a link pdf image link of what the pdf looks like but I can provide the pdf file as a link too
I've tried copying and pasting, using the excel text import wizard, and converting the file in acrobat and online but every time I always end up with multiple (30-100) line entries in the same excel cell.
The answer's probably something really simple but for the life of me, I can't figure out how to do it.
If anyone of the wonderful excel experts here has any ideas or solutions, it'd be super appreciated.


I've been scratching my head all day with this issue and it's really getting to me. I have a PDF doc containing a list of; suburbs/cities along with their postal code and state, organised in 7 columns across 35 pages on an A4 page.
What I'm trying to do, is to copy/import all this data into an excel worksheet, with each PDF line copied into a separate excel row.
This is an example of how I'd love the data to look like in excel. I've also put a link pdf image link of what the pdf looks like but I can provide the pdf file as a link too
ARRINO WA 6519 |
ARROWSMITH WA 6525 |
ARROWSMITH EAST WA 6519 |
ARTARMON NSW 1570 |
ARTARMON NSW 2064 |
ARTHUR RIVER WA 6315 |
ARTHUR RIVER TAS 7330 |
ARTHURS CREEK VIC 3099 |
ARTHURS LAKE TAS 7030 |
ARTHURS SEAT VIC 3936 |
ARTHURTON SA 5572 |
I've tried copying and pasting, using the excel text import wizard, and converting the file in acrobat and online but every time I always end up with multiple (30-100) line entries in the same excel cell.
The answer's probably something really simple but for the life of me, I can't figure out how to do it.
If anyone of the wonderful excel experts here has any ideas or solutions, it'd be super appreciated.

