HELP PLEASE!! MASSIVE amounts of data needing to be imported from one text file.

I have a .txt file that has 16 and a half million lines code, and it contains 7 columns in each line (X,Y,Z,Intensity,R,G,B). I have to strip the intensity out of each line, which is easy to do since i can import the text and use text to columns, and simply delete the 4th column out. The problem is i have to split the text file up into (roughly) 17 different .txt files and work through them one at a time. Is there any way to tell excel to keep loading the text in (move from loading into cells A,B,C,D,E,F,G over to cells (H,I,J,K,L,M,N) and do this over and over again until i have a million lines in each column, and have this spread out horizontally 16 times? Either through a macro, or using a function in the last line possible in excel (say A1048576) to spit any data coming its way up to H1, so that it keeps loading from there?

Thanks everyone! I'm going to try PowerPivot and see where that gets me. I had never heard of it before so we will see how it goes i guess!