DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes? (more ...)

Features | Testimonial | Download free 15-day trial | Purchase | FAQ | Contact

Split a Table (List) into Sub Tables

Split table by values in column(s)

  1. Click a single cell in your table area. Invoke 'DigDB->Table->Split->by Values in Column(s)...', the table area will be automatically selected.

    Split Table, List
    Practice file - split-table-list-sub-demo.xls (16k)

  2. Select using which column(s) to split the table by

    Split Table, List

    You can use the 'Add Column >>' button to add multiple columns to split by. For example, instead of breaking the list into subsets by 'age', you can break it apart by each unique combination of 'color' and 'body_mark', then you will need to add the two columns to the split-by criteria.

  3. Select where to put the sub tables. Each sub table can be in a new sheet, new file (workbook), or next to each other.

    Split Table, List

  4. Click OK. Result of the split: 5 new sheets, each sheet has a subtable, the name of the sheets is set to the corresponding values in the column.

    Split Table, List

Split table by fixed number of rows

  1. Click a single cell within your table area. Invoke 'DigDB->Table->Split->by Number of Rows...'. The table area will be automatically selected.

    Split Table, List
    Practice file - split-table-list-sub-demo.xls (16k)

  2. Set the options.

    Split Table, List

    You can select where to put the sub tables. Each sub table can be in a new sheet, new file (workbook), or next to each other.

    Split Table, List

  3. Result after the split:

    Split Table, List

Need more?


Features | Testimonial | Download | Purchase | FAQ | Contact (free forum)

Copyright © 1999-2007 All rights reserved

DigDB      Excel Add-ins      Add-in Tools for Excel Elites
Who else wants to do a 10-hour Excel analysis in 15 minutes?

Related keywords: Advanced excel tips, excel questions tools, Excel reporting applications, Excel add-ins add-in, Excel shareware, Excel plugin plug-ins plugins, Excel tricks question, Excel utility utilities, Excel add-on add-ons, Excel tip tips, Power excel technique, Excel manipluation, Excel guru, Excel trick, Excel toolkit, Excel app power user

Microsoft Office Marketplace logo
Microsoft and the Office logo are trademarks or registered trademarks of
Microsoft Corporation in the United States and/or other countries.