Transposing All but the First Column in a DataFrame Using Pandas.

Transposing Columns with Aggregate Functions into Rows Using SQL Server: Limitations and Alternative Approaches