Have a look at using the transformation step which is available on step 2 of the table wizard when doing the data load.
Pre-Sales Solutions Consultant
NOTICE: If received in error, please destroy and notify sender. Sender does not waive confidentiality or privilege, and use is prohibited. QlikTech UK Limited, registered in England and Wales with number 5292408, and whose registered office is Villiers House, Clarendon Avenue, Leamington Spa, Warwickshire, CV32 5PR.
If I understand you right, a crosstable load would help, so the months are loaded as field month and its different values, column A is loaded as it is and values are loaded as values. Not tested, but the script should look like
Data: CROSSTABLE (Type, Month, Values) LOAD * FROM ExcelFile.xls (....);
Then in the new chart, you can pivot the types to be vertical at the top and so.
EDIT: By the way, transposing is available for QVD files as well (actually, for any table file), so you can load your excel files, store into QVD, then do the transposing when loading the QVDs. I don't see any particular advantage in this double step, but you may find it useful.
Hope that helps.