Normalizing data

People frequently enter data into excel in the format they expect to see a report in. In other words, they do things like put dates in columns and add a new column for each day. While this makes data entry easy, it pretty much limits the report ot one view of the data. Getting things like model sales by month or weeks becomes an exercise in untangling the data.

The attached is a brief tutorial on what normalized data is, and has a utility that should work in most cases to normalize data that is entered in tabular format.