Unorganized text into organized table

Glad I stumbled across this forum as I've learned many nifty tricks and new things!
This is my issue maybe someone can guide me in the right direction.


My Goal is to have 8 Columns, with rows of data under the columns. "8 columns by 64000 rows"



Here is the Outcome I'm looking for. My project is 800 pages "about 20mb" pdf to word file.
When I copy into excel I get everything into one column not multiple
When I do anything Delimit It destroys the layout even more. I'm at a loss
I've tried converting text into a table and converting rows into columns which did not help.
I would like to remove or not import information like Follow up and Ctgy
Is this possible without manual data entry?
Or will I have to find a programmer/coder?
Skill level - I'm a normal user on excel, but very computer savy.
Here is what It would kind of look like as a finished product in my eyes.

Jobs
**FCI ** - Foreclosure Inspection -
**RD ** - Reporting Deduction --
Jobs will not be a abbreviation just doing this to save time here on the forum and keep the table looking somewhat nice :D


Ap invoice number | Property ID | Job | Work Order | Assigned | Received | Amount | JobTotal
12412312 | 19421342 | FCI | 243423324 | 07/1/12 | 8/16/12 | 6.0 | 6.0
| RD | | -3.0 | 3.0
| 53453453 | FCI | 222535355 | 06/24/12 | 7/22/12 | 6.0 | 6.0

14322312 | 19221342 | FCI | 243422224 | 05/12/12 | 6/16/12 | 6.0 | 6.0
| RD | | -3.0 | 3.0
| 53223453 | FCI | 222535355 | 05/24/12 |7/14/12 | 6.0 6.0

Since my text fails here is a picture of screen shot

helpplease.jpg

Here is a piece of what i'm starting with. There is 800 pages of this




Contractor: 11115
JOHN J DOE

1234 EXCEL AVENUE
TAMPA
, FL 33614

AP Invoice Number: 19272332



Property ID Job Work Order Assigned Follow up Received Amount
--------------- ---- ----------- --------- --------- -------- -----------
19411759 232361527 07/17/12 08/16/12
Ctgy: Foreclosure Inspection 6.00

Job Total: 6.00

22312707 215519522 07/17/12 07/28/12
Ctgy: Foreclosure Inspection 6.00

Job Total: 6.00

21600996 235804410 08/02/12 08/11/12
Ctgy: Occupancy Determination 6.00

Photograph Non-regulatory 0.00

Job Total: 6.00

20817173 235104516 08/02/12 08/22/12
Ctgy: Occupancy Determination 6.00

Photograph Non-regulatory 0.00

Job Total: 6.00

21110268 235204525 08/02/12 08/23/12
Ctgy: Foreclosure Inspection 0.00

Job Total: 0.00

Welcome to the Forum, Ravisher.

DO take a moment to peruse the Forum Rules (Link is above in the blue menu bar), there are many useful rules and tips on getting the most out of the forum and encouraging speedy replies.

For something complex like this, post a sample workbook with a nice set of sample data, perhaps a bit longer than your pictured example, along with the desired results.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Thanks.

Pulling the data from where? A text file? A csv file? Post the sample source file, too.

Do you have the original sample.txt file?