Overview for Unstack Columns

Use Unstack Columns to copy data from one or more columns into shorter columns, by values in one or more grouping columns. Each resulting column contains the observations from one group.

For example, a sales manager wants to analyze sales data for a single store, but the sales data for all stores are in one column. The manager unstacks the sales data so that each store's sales are in a separate column. In the following worksheet, the Sales column contains the sales data. The Store column contains the location for each store. Columns C3–C5 contain the unstacked sales data, by location.