Unpivot transformation in SSIS (SQL Server Integration Services 2008)
More SSIS tutorials at http://www.analyticsinaction.com/category/data-integration/. How to use the Unpivot Transformation in SSIS – Integration Services in SQL 2008.
I also have a comprehensive 60 minute T-SQL course available at Udemy : https://www.udemy.com/t-sql-for-data-analysts/?couponCode=ANALYTICS50%25OFF