The Unpivot Columns in Excel application of Optipe Data Tools Suite allows you to rotate or unpivot Excel columns with data distributed in a two-dimensional array. The result table may be used as database for Pivot Tables.
Use this application to:
- Prepare data so they can be read as a database in Pivot Tables.
- Transform data from systems, the Internet or other PivotTable reports.
Features:
- Easily select fields or columns to unpivot.
- Skip blanks and/or zeros.
- You can define names for the resulting columns (fields and values names).
- To select a consecutive group of fields, click the first item, press and hold down the Shift key, and then click the last item.
- To select non-consecutive fields, press and hold down the Ctrl key, and then click each item that you want to select.
See also:
Examples:
Video Example. Unpivot columns.
