Split Excel Master Table Into Sub-table

How To Split Excel Master Table Into Sub-table ?I have a main table which consist of over 100000 records and I have a field which is called Branch ? Product. Each Product has 12 KPIs in the data. what I would like to do is create sub-tables contains all 12 KPIs for each product. I just want to know what is the best way to do this?? The Split Excel Master Table Into Sub-table is a utility that helps you quickly and easily split your data into separate worksheets. Whether you need to split you data by rows for each Sales Team, or by columns for each Region, Split Excel Master Table Into Sub-table will do the trick in seconds. Stop wasting time copying and pasting data manually. Let Split Excel Master Table Into Sub-table to do the work for you. With Split Excel Master Table Into Sub-table, split a main table just need simple steps and a few options to set. Open a Excel file Select the Master table in all the sheets Open the master table Set the options Preview Split Feature List all sheets in the workbook automatically Support to split the master table by rows or by columns Option to control whether the sub-table keep the header in the master table Preview before split the master table, what you see is what you get Support reading and creating ?Excel 97-2003 workbooks (*.xls)? and ?Excel workbook (*.xlsx)? file Support Office 2007, 2010 Portable Software