• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 1. Misusing Excel as a Database ... > Transposing Rows and Columns

Transposing Rows and Columns

Excel is not a database management system. It is not, for example, designed to manage the relationship between parent and child records. To extend the example in the previous section, a PO is a parent record and invoices are child records because each invoice—the child record—belongs to a PO—the parent record.

Still, Excel has some rudimentary database features, among them the AutoFilter and the Advanced Filter. These two filters in particular depend on a particular orientation of your data, called lists. In Excel, a list has these characteristics:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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