Consolidating crosstab data

This is a continuation of the Data Cleanup series. One common form of bad data is called crosstab. Consolidating this type of data requires lot of manual effort. Pivot РMultiple Consolidation Ranges is a fantastic feature available in Excel which can do this job in a snap. Here is an example of cross tab data…

image

Let us see how to get this done.

image

Continue reading