040480-00 HOLLON #26-1@ OK WOODWARD
09/15 G 1562 1.22 2.49 3,895.79 3,649.51 1.0000000 WI 3,895.79 3,173.26
TOKER -3.42 FEXMPP -476.25
TOKEX -3.25
TOKMR -0.24
TOKPR -239.37
09/15 G -1562 1.22 .0000 -3,895.06 -3,614.57 1.0000000 WI -3,895.06 -3,138.32
TOKER 3.90 FEXMPP 476.25
TOKEX 3.70
TOKMR 0.24
TOKPR 272.65

The above data is an example of how a converted pdf file gets parsed as if gets converted and is resaved as an xlsx file. The next 6 or 7 rows are basically a record that has to be joined together to form one row in a table. I can do that one with =match formulas. The problem comes with the second occurrence starting with "09/15 G -1562" and this group continues on the next 6 or 7 rows below that.

The problem I am asking for help on has to do with the top line identifier information. I need to be able to create a formula for the 2nd record say from rows 9 to 15 to also pull the identifier found on row 1 to also associate this line with it as well as with the first row.

The simplified table below is what I am after. The headers were created as desired and are not part of this particular file I brought in but are part of the table structure I am looking to create

Sales Month Meter Well Name Mcfs Gross
09/15 040480 HOLLON #26-1 1562 3,895.79
09/15 040480 HOLLON #26-1 -1562 -3,614.57


Can this sort of thing be done with combinations of index and match, or is it easier to create a looping marco? Either way, there are thousands of such rows, and the top record information on this page will be changing in some variation but it will not be in a predictable patter, and sometimes that record contained in meter and well name in the example table above will not show up consistently in the same excel column when it gets parsed by pdf converter,

Can someone get me started on this please?

Thanks,


Bruce