input over 20000 data readings to the excel sheet by converting row to column
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