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

Consolidations

The Consolidate command lets you combine data from multiple sources. Excel lets you do this in two ways:

  • Consolidate based on the arrangement of data. This is useful when data occupies the same number of cells in the same arrangement in multiple locations (Figure 3).

  • Consolidate based on identifying labels or categories. This is useful when the arrangement of data varies from one source to the next.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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