O'Reilly logo
  • Joe Kushner thinks this is interesting:

Assume that the only way you are able to get some data for analysis is in the form of the Excel spreadsheet pictured in Figure 3.5, which is obviously not normalized.


Cover of Effective SQL: 61 Specific Ways to Write Better SQL, First Edition


Using UNION to Un-Pivotize Excel Data.