Hello @knimecr,
currently Excel Reader (XLS) node can only write raw data into new sheet. With above mentioned Continental nodes you can then format your sheet. So pivot Excel tables can not be created from within KNIME. See here for some ideas/suggestions:
Br, Ivan