Transposing rows and columns in SQL Server Integration Services

Okay, this was a rough one. The challenge was that a customer had Excel spreadsheets where we needed to transpose the rows and columns. In other words, the spreadsheet looked like this: But we needed the records to list Program values by date, like this: Of course, I did that by simply copying the cells…

1