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...
[read more]
Submit a review:
Login required.