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.

From

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

Note

Using UNION to Un-Pivotize Excel Data.