I have a flat file source from Excel that has a structure like this:

**People**  Day1           Day2            Day3            Day4
Person1     someValue      ...
Person2     
Person3

And i would like the package to put this information in a database with standard columns 'Person', 'Day', 'Value'. Does anybody know how to do this - at the moment because the days are going along the top, the package is assuming these are seperate data columns when they are not really and the mapping is not working.