I realize there is a simple non SQL solution, however this is a pure sql solution. It may not be as slow as you think. This is the case where you do not have column names in your input table SAS does ...

This script allows you to import a csv file and transpose the data inside just like you do it in Excel, with some limitations. Its irrespective of the length and size of the table. It automatically ...