Below is what I am after, but unfortunately the file sizes are just slightly above the 100kb limit, So I hosted the files elsewhere:

File1-T21496.txt: http://www.mediafire.com/?jqp1ld00jop
File2-T21525.txt: http://www.mediafire.com/?1nwycysgybk
File3-Longhorn Dodge(TX6125)Table 4_Soil.xls: http://www.mediafire.com/?2pr9gwwixsh

If you figure this out can you please let me know the steps to recreating it.

I would really appreciate some help with this and would like to be able to automate this process someday since I will be having a lot of this type of work coming in.

The two txt files needed to be merged into one file and only the columns shown on the final table need to be converted to the excel spreadsheet. I also want the data in numeric order with the BALLIN designated well as the last column and the TB locations (4 of them) just in front of the BALLIN well. I do not need the TB – trip blank data included and I don’t need the designation well, piezo, boring after each ID included. For ex. Only need to sere MW0217 not MW0217/WELL.

Also note that in the Crosstab2 TAB, for this Ballinger data, I need 4 blank columns. I see the Longhorn example has 4 columns, so I don’t know if I added the additional columns after she set up the table. Refer to the Print Preview to see how the overall table is set up with headers and footers so you see your spacing limitations.