How to import text file with 20,000 columns?

Dear Sergei,

If the original data had been transposed prior to saving in the text file, there would be no problem; 20,000 rows x 500 columns is easy to import.  The data set would be ready to mine.

I tried your recommendation, but it may not be suitable for the structure of my data set.  I am able to import big blocks of merged columns using the text import wizard based on fixed width, but defining the fixed widths is tough to do in the tiny preview window, and then deleting some blocks so that the total is less than the 16,384 excel limit requires some guessing, and then matching the data columns (not in quotes) to the column names (are in quotes), because they are not aligned, makes it even more difficult.  Separating the blocks of columns into columns in excel worked well except for the cells on the left and right edges of the blocks.  These cells lost data to adjacent blocks.  There must be another solution. 

It might be best to (1) split the original text file and import into excel into two different sheets, transpose each, and then combine, or (2) use a macro in excel to import, or (3) maybe use a pivot table if this is possible, to connect to the remote text file with 20K columns, and import or add to the destination sheet's pivot table just 10K columns or transpose them to rows, but I am not sure how to automate this.  The main point of (3) is to have the excel file connect to a source text file or database to extract just what is called up to avoid exceeding the 16K limit on columns.

What do you recommend?

Thanks,

Ralph