in the data file I have more than 20000 readings that cannot be directly loaded to the excel sheet. I want to transpose the data in the file to column and load it to the sheet as a column. How can I do this inside VBA or with separate program.
simple transpose does not work