Microsoft Excel's CHOOSECOLS and CHOOSEROWS functions are a ... Excel tables don't mix, if you want to format the result, you'll have to do so manually or by using conditional formatting.