Split uneven data from a single columns to multiple columns

Hi all,

I wonder if anyone can help with this complicated problem.

I have a large amount of data that is on A5 paper, I have scanned all the data (6,000 plus) and have them in a pdf document, I am able to then convert this pdf into excel using adobe online, but unfortunatley it converts all fields into a single column with 40,000 plus rows.

I also have an excel spreadsheet with 250,000 records, all formatted nicely in columns for name, address, postcode etc, what I need to do is check for duplicates within the two sets of data.

If I could change the converted data into columns with headings, then I am certain I can run some kind of lookup formula to complete the task, but with the data in a single column this is not going to be posible.

Through this forum I have found how to split single colums into multiple columns, but unfortuanely my converted data varies in length from record to record, and as part of the convertion it also brings in a few abnormalities like the barcodes.

In summary what I need to do is find a way of putting the data from a single column into multiple columns but by looking at what it is moving.

I have attached a snap shot of the data both in the raw form and converted (manually), (names and addresses have been chaged).

Thank You in anticipation.