Design Pattern: Transpose cleanse Cross Tab

Transposing data puts the values of many fields into one column. With the data shaped in this was it is easy to make transformations to the data such as cleansing. After this the design pattern is bookended with a cross tab to reshape the data.