Unstack Columns

SPC XL 2010 supports a new feature called "Unstack Data". This feature will move data from a database or flat file format to a column structure.

Simple Example

Source Data - The left column has subscripts or groups. Data from a database commonly comes in this format.

Select "SPC XL" - "Quality Tools" - "Unstack Columns".

The "Subscripts Range" is the column with type (different types of cars) and the "Data Range" is the column with Ticket Rate.

Result after Unstacking...

Advanced Example

Both the Subscripts and the data range can be more than one column. For example, with the following data...

... if you unstack using columns A and B as the subscripts and columns C and D as the data range...

.. the result will be an unstacked Region,

and an unstacked Type.