1. Launch Microsoft Excel
2. Highlight the rows and columns you want to split
3. From the DATA tab, select Outline
4. At the bottom of the window you will see two buttons marked Subtotal and Summary
5. Select Subtotal and mark the column you want to base your split on
6. On the following window you will be able to select the type of operation you would like to perform, and the range wherein you would like to split the original table
7. Click on Ok to confirm your selection, and you're retidy to go!