Philo's WebLogMusings of a former Office Developer EvangelistTransposing rows and columns in SQL Server Integration Services- November 10, 2007 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 and doing a "Paste Transpose" in Excel. But when you have several hundred spreadsheets being used by folks, that's a nontrivial operation. At first it looked like my only option was going...http://blogs.msdn.com/philoj/archive/2007/11/10/transposing-rows-and-columns-in-sql-server... |