You haven't shown what the data in your table looks like, but I think I can picture it.

It looks as if you have three options:

(1) Pivot in Excel then load directly into the table

(2) Pivot as part of your data flow and load directly into the table

(3) Load into a staging table, then do a T-SQL PIVOT into your table

John