When it comes to crosstable loads, I always do one of both
- Do the crosstable load using * and then a second load resident from the previous renaming and changing
- Use the Transformation Step to change what you need to change and then do the crosstable load
Anyway, taking a look at your code, you are using the frist 6 columns (those taht are not going to be cross loaded) but you don't add in the LOAD part those columns that correspond to the MasterDate and ProfileValue, so my guessis that your script should look like
Profiles: CrossTable(MasterDate, ProfileValue, 6) LOAD Programme, Flow, District, Centre as TR_Office, Company as TR_Company, Description as Profile_Description, // Rest of the columns here // If there are too much, then let the wizard write them for you FROM WP_ProfileTest.xlsx (ooxml, embedded labels, table is Sheet1);
Hope that helps.