Probably easiest to use a pivot table. Highlight the data and then select
Data -> Pivot Table. The Pivot Table Wizard will pop up. You can either
follow the wizard of just hit finish (the default should be good enough). A
new sheet will be created with a pivot table on it. Drag the Number of
division to the middle and the Status and markets to the left column. Drag
the fields around until you get it looking the way you want it to... If you
want you can add a format to it to make it look fance by just selecting a
format from the pivot table tool bar...