If I understand your problem correctly, I think that the Unpivot transformation should work.

http://msdn2.microsoft.com/en-us/library/ms141723.aspx