Hi. I have a CSV file (the output of test machine) which has 1000 values per line (numeric & text) with line length of 10,000 characters. There will be between 1 & 50 lines in each file. If I can transpose the rows & columns then excel will handle the data. Is there a way within excel to do this at load time, do I need VB code, or an external application to do this transposation?
Thanks in advance, Joe.
Thanks in advance, Joe.