You might use the Transpose function from within Excel to swap columns for rows of data prior to importing.
If not, your script would need to import the data in to a temporary table and then loop through the records and fields moving data from the temp table into new records in the table into which you want to import this data.
Transpose. That's also the work-around that I chose. Easier than a script. Thanks and regards.