• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Consolidating Data

If you establish several lists or tables that have similar setups, you'll probably want to combine certain sets of data from these separate lists or tables into one consolidated list or table. Excel enables you to consolidate tables with the Consolidate command on the Data menu. Consolidation allows for analysis of the tables or lists with functions provided in the Consolidate dialog box.

The best way to consolidate a list or table is to set up a table that represents the format and layout of the original tables, like the example shown in Figure 19.12. Consolidation isn't limited to a worksheet or a workbook—you can consolidate data from the same worksheet, a different worksheet in the same workbook, other workbooks, or even from Lotus 1-2-3 files.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint