sure. Transposing is a function you have in the LOAD wizard in QlikView. I use it quite often when the data in Excel that I want to load is in a Crosstab-like structure - it's a bit more complex than doing a crosstab_load, but I think it is more powerful.
Just open the wizard in the script_editor (by clicking on "spreadsheets") and on the second screen, enter the editing_mode. Transposing is an option on the "rotate" tab.
Did you try CrossTable?
Select Excel File you need from Table files in Script and then use file wizard for the cross table.
Yes, forgot that option, as datanibbler said, Try Rotate/Transpose option from Enable Transformation Step in file wizard of the script.