Convert rows to columns in SSIS. Unpivot?
Yes the Unpivot Transformation should work, as long as the number of input columns does not vary.

Looking at your example, it looks like [Column 2] (e.g. WAREHOUSE ID) should be set as the Pivot Key Value.  You can ignore any output columns that you dont want to output e.g. the Pivot Key Value Column Name.