Insert a temporary column to the left (ie Col A)and number the rows 1,2,3....
Sort with Col B so that headers will be together and then delete header rows
Sort them with ColA ie the sequence number..
Delete the temporary Col A

If this post helps click Yes
---------------
Jacob Skaria


"Steve Haack" wrote:

I need to import data into Excel for statistical analysis. The data is being
collected from thousands of PC's in an organization. Each of them generates a
"log" file and places it on a server.

Each file is a text file, tab delimited with a header row, and a data row.
Each file imports perfectly into Excel.

What I would like to do, is concatenate the files into one file, then import
the entire file. I am able to do this by doing: "copy *.log concatenated.txt"
and it creates one file which imports fine.

The problem is that in this concatenated file, every other line is a repeat
of the column headers.

Is there an easy way in Excel to import that file and recognize every other
line as headers and reject them? I am using Excel 2007.

Thanks,
Steve