When working with information in Excel, one often has to transform the data in some way. Transforming it generally means cleaning, standardizing, or shaping data in ways that are appropriate for the work. This can mean anything from cleaning out extra spaces, to padding numbers with zeros, to filtering data for certain criteria. The macros in this chapter show some of the more useful macros that one can use to dynamically transform the data in the workbooks. These macros can be combined into one, and each piece of code can be run in a sequence that essentially automates the scrubbing and shaping of the data.